Skip to content

NTSB investigations, 1973

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE year(c."eventDate") = 1973 ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
  FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
  WHERE year(c.\"eventDate\") = 1973
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE year(c."eventDate") = 1973
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB FTW74FPM11Accident · No injuriesClosedPiper PA-24 · Tulsa, OKNov 18, 1973 · N8272P · Substantial damage NTSB FTW74AF033Accident · 1 fatalClosedCessna 150F · Plano, TXNov 18, 1973 · N8336G · Destroyed NTSB DEN74AD024Accident · 1 fatalClosedBellanca 8KCAB · Santa Fe, NMNov 18, 1973 · N36033 · Destroyed NTSB CHI74DEE35Accident · No injuriesClosedBeech 23-19 · Moline, ILNov 18, 1973 · N6091N · Substantial damage NTSB ANC74DAG80Accident · Minor injuriesClosedPiper J-3 · Kodiak, AKNov 18, 1973 · N6069H · Substantial damage NTSB SEA74DYC24Accident · No injuriesClosedPiper PA-22 · Mosier, ORNov 17, 1973 · N5912Z · Substantial damage NTSB OAK73IP020Incident · No injuriesClosedSikorsky S-61N · Oakland, CANov 17, 1973 · N4606G · Minor damage NTSB MIA74DKT38Accident · No injuriesClosedCamair 480 · Lantana, FLNov 17, 1973 · N215 · Substantial damage NTSB LAX74AL037Accident · 1 fatalClosedPiper PA-24 · San Dimas, CANov 17, 1973 · N5531P · Destroyed NTSB FTW74FQG28Accident · Minor injuriesClosedN.American AT-6 · Shallowater, TXNov 17, 1973 · N7000S · Substantial damage NTSB FTW74AF032Accident · 1 fatalClosedPitts S-2A · Bogalusa, LANov 17, 1973 · N80022 · Destroyed NTSB FTW74AF031Accident · 2 fatalClosedCessna 150D · Melville, LANov 17, 1973 · N4113U · Destroyed NTSB DEN74AD023Accident · 2 fatalClosedCessna 120 · Wiggins, CONov 17, 1973 · N3754V · Destroyed NTSB CHI74DEV28Accident · No injuriesClosedCessna T210F · Peoria, ILNov 17, 1973 · N6191R · Substantial damage NTSB ANC74FAG81Accident · Serious injuriesClosedTaylorcraft BC12-D · Skwentna, AKNov 17, 1973 · N96188 · Substantial damage NTSB ANC74DAG79Accident · No injuriesClosedPiper PA-18 · Talkeetna, AKNov 17, 1973 · N215T · Substantial damage NTSB ANC74AA045Accident · 3 fatalClosedCessna 170 · Anchorage, AKNov 17, 1973 · N9058A · Destroyed NTSB NYC74AN043Accident · 4 fatalClosedCessna 402B · W Stockbrdge, MANov 16, 1973 · N50YL · Destroyed NTSB MKC74AK024Accident · No injuriesClosedPiper PA-32 · Topeka, KSNov 16, 1973 · N3412W · Substantial damage NTSB MIA74AM043Accident · 2 fatalClosedBeech E55 · Decatur, GANov 16, 1973 · N3917A · Destroyed NTSB FTW74DRG34Accident · No injuriesClosedMorane FI156C · Harlingen, TXNov 16, 1973 · N43FS · Substantial damage NTSB FTW74DPD28Accident · No injuriesClosedPiper PA-20 · Denton, TXNov 16, 1973 · N7714K · Substantial damage NTSB FTW74DPA11Accident · No injuriesClosedCallair A-9 · Wilson, TXNov 16, 1973 · N3583G · Substantial damage NTSB DEN74DTC20Accident · No injuriesClosedPiper PA-25 · Upton, WYNov 16, 1973 · N6393Z · Substantial damage NTSB ANC74DAA21Accident · No injuriesClosedPiper PA-16 · North Pole, AKNov 16, 1973 · N5776H · Substantial damage NTSB OAK74DVA33Accident · No injuriesClosedBoeing A75 · Hickman, CANov 15, 1973 · N56416 · Substantial damage NTSB LAX74DUM11Accident · No injuriesClosedPiper PA-34 · Santee, CANov 15, 1973 · N1025U · Substantial damage NTSB LAX74AL036Accident · 3 fatalClosedPiper PA-23 · Alpine, CANov 15, 1973 · N6694Y · Destroyed NTSB IAD74FLJ22Accident · Minor injuriesClosedBell 47G-4 · Aulander, NCNov 15, 1973 · N73276 · Substantial damage NTSB FTW74FPD26Accident · 1 fatalClosedPiper PA-25 · Munday, TXNov 15, 1973 · N6915Z · Destroyed NTSB FTW74DQG31Accident · No injuriesClosedGrumman G-164 · Waka, TXNov 15, 1973 · N6592 · Destroyed NTSB CHI74FEE33Accident · No injuriesClosedCessna 210H · Rockford, ILNov 15, 1973 · N5991F · Substantial damage NTSB OAK74DVG19Accident · No injuriesClosedPiper PA-28 · Rio Linda, CANov 14, 1973 · N1671J · Substantial damage NTSB MKC74AK023Accident · 1 fatalClosedTaylorcraft BC12-D · Fairbury, NENov 14, 1973 · N5041M · Destroyed NTSB MKC74AK022Accident · 2 fatalClosedMaule M4-220 · Independence, IANov 14, 1973 · N40320 · Destroyed NTSB MIA74FLG16Accident · Serious injuriesClosedBeech A35 · Easley, SCNov 14, 1973 · N528B · Destroyed NTSB MIA74FLG15Accident · No injuriesClosedMeyers 200B · Savannah, GANov 14, 1973 · N357CE · Substantial damage NTSB MIA74FKG43Accident · No injuriesClosedN.American 600S2R · Albany, GANov 14, 1973 · N5645X · Substantial damage NTSB IAD74II026Incident · No injuriesClosedBeech D18S · Knoxville, TNNov 14, 1973 · N3556C · Minor damage NTSB IAD74DLJ21Accident · No injuriesClosedCessna 172F · Raeford, NCNov 14, 1973 · N5652R · Substantial damage NTSB DEN74FTE30Accident · Minor injuriesClosedHughes 269B · Broomfield, CONov 14, 1973 · N9440F · Substantial damage NTSB CHI74FEM27Accident · Minor injuriesClosedCessna 150 · Rockford, MINov 14, 1973 · N6853G · Substantial damage NTSB CHI74AC042Accident · 5 fatalClosedCessna 421 · Plymouth, INNov 14, 1973 · N550T · Destroyed NTSB NYC74FHD21Accident · No injuriesClosedCessna 150L · Pitman, NJNov 13, 1973 · N6535G · Substantial damage NTSB NYC74DNA25Accident · No injuriesClosedAmer Avco AA-1A · Bedford, MANov 13, 1973 · N9411L · Substantial damage NTSB MKC74DTK05Accident · Serious injuriesClosedCessna 150 · Sturgis, SDNov 13, 1973 · N8209S · Substantial damage NTSB MIA74AM042Accident · No injuriesClosedBeech E18S · San Juan, PRNov 13, 1973 · N3628B · Substantial damage NTSB IAD74FIG13Accident · No injuriesClosedPiper PA-24 · Aldino, MDNov 13, 1973 · N6970P · Substantial damage NTSB FTW74AF030Accident · Minor injuriesClosedBell 206B · Intracstl Cty, LANov 13, 1973 · N2929W · Substantial damage NTSB MKC74FER22Accident · 1 fatalClosedVolmer VJ-22 · Prior Lake, MNNov 12, 1973 · N1007N · Destroyed