Skip to content

NTSB investigations, 1973

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 CHI74DEP24Accident · No injuriesClosedCessna 150 · Crivitz, WIDec 10, 1973 · N10772 · Substantial damage NTSB OAK74DVD19Accident · Minor injuriesClosedBeech A35 · Stockton, CADec 9, 1973 · N8630A · Substantial damage NTSB MIA74FKA07Accident · No injuriesClosedCessna 150 · Humacao, PRDec 9, 1973 · N1707Q · Substantial damage NTSB FTW74FPJ17Accident · No injuriesClosedPiper PA-32 · Stillwater, OKDec 9, 1973 · N8953N · Substantial damage NTSB FTW74DRG42Accident · No injuriesClosedMooney M20C · San Antonio, TXDec 9, 1973 · CF-PXG · Substantial damage NTSB CHI74FEK09Accident · No injuriesClosedAero Comdr 500B · Findly, OHDec 9, 1973 · N354MA · Substantial damage NTSB CHI74DET15Accident · No injuriesClosedBeech A35 · Logansport, INDec 9, 1973 · N708B · Destroyed NTSB CHI74AC040Accident · No injuriesClosedBoeing 727 · Madison, WIDec 9, 1973 · N259US · Substantial damage NTSB SEA74DYC31Accident · Minor injuriesClosedCallair A-5T · Siletz, ORDec 8, 1973 · N6030C · Substantial damage NTSB OAK74FVG20Accident · 1 fatalClosedSemco T · Chico, CADec 8, 1973 · N9975 · Substantial damage NTSB OAK74DVM16Accident · No injuriesClosedBeech 35 · Moss Beach, CADec 8, 1973 · N11E · Substantial damage NTSB NYC74FHD28Accident · 1 fatalClosedTaylor Mono · Millville, NJDec 8, 1973 · N71RC · Destroyed NTSB NYC74AN052Accident · 2 fatalClosedBeech G35 · Chaplin, CTDec 8, 1973 · N118B · Destroyed NTSB MKC74DTG11Accident · No injuriesClosedCessna 172 · Bowman, NDDec 8, 1973 · N5076A · Substantial damage NTSB LAX74DUG28Accident · No injuriesClosedSchweizer SGS126 · Llano, CADec 8, 1973 · N7582 · Substantial damage NTSB LAX74AUQ22Accident · No injuriesClosedPiper PA-28 · Valencia, CADec 8, 1973 · N6852W · Substantial damage NTSB FTW74FPG40Accident · No injuriesClosedBeech E55 · Fort Smith, ARDec 8, 1973 · N22JF · Substantial damage NTSB CHI74FEI17Accident · No injuriesClosedMooney M20B · Elyria, OHDec 8, 1973 · N74585 · Substantial damage NTSB CHI74AC047Accident · 1 fatalClosedChampion 7GCAA · South Haven, MIDec 8, 1973 · N1122 · Destroyed NTSB NYC74FHM13Accident · Serious injuriesClosedCessna 150L · Linden, NJDec 7, 1973 · N1688Q · Substantial damage NTSB NYC74AN051Accident · 2 fatalClosedBeech E18S · Corapolis, PADec 7, 1973 · N387B · Destroyed NTSB MIA74FKT41Accident · No injuriesClosedAero Comdr 112 · Opa Locka, FLDec 7, 1973 · N1105J · Substantial damage NTSB IAD74AI033Accident · Minor injuriesClosedBeech D18 · Covington, KYDec 7, 1973 · N199L · Substantial damage NTSB FTW74DRD20Accident · 2 fatalClosedCessna 182 · Mexico City, MexicoDec 7, 1973 · N869TX · Substantial damage NTSB MKC74FER25Accident · Minor injuriesClosedCessna 180J · Crystal, MNDec 6, 1973 · N42936 · Substantial damage NTSB IAD74FID23Accident · No injuriesClosedCessna 172C · Moneta, VADec 6, 1973 · N1840Y · Substantial damage NTSB IAD74AI032Accident · No injuriesClosedDehavilland DH-104 · Knoxville, TNDec 6, 1973 · N10BB · Substantial damage NTSB FTW74FPD31Accident · Minor injuriesClosedPiper PA-22 · Grapevine, TXDec 6, 1973 · N1176C · Substantial damage NTSB CHI74FEC21Accident · Minor injuriesClosedCessna 177 · Lapeer, MIDec 6, 1973 · N34150 · Substantial damage NTSB SEA74IS025Incident · No injuriesClosedBoeing 720A · Moses Lake, WADec 5, 1973 · N7225U · Minor damage NTSB SEA74FYC27Accident · No injuriesClosedNavion G · Salem, ORDec 5, 1973 · N2453T · Substantial damage NTSB OAK74FJA09Accident · No injuriesClosedHughes 269A · Kahalui, HIDec 5, 1973 · N8732F · Substantial damage NTSB OAK74DVA37Accident · No injuriesClosedPiper PA-25 · Merced, CADec 5, 1973 · N4769Y · Substantial damage NTSB OAK74AP022Accident · 2 fatalClosedCessna 120 · Columbia, CADec 5, 1973 · N1719N · Destroyed NTSB NYC73FHJ12Accident · No injuriesClosedAero Comdr 680W · White Plains, NYDec 5, 1973 · N5029E · Substantial damage NTSB MIA74FLA28Accident · No injuriesClosedBeech 65-80 · Crestview, FLDec 5, 1973 · N741H · Substantial damage NTSB MIA74DLA27Accident · No injuriesClosedCessna 175 · Cherry Lake, FLDec 5, 1973 · N7366M · Substantial damage NTSB LAX74DUJ39Accident · No injuriesClosedPiper PA-28 · Douglas, AZDec 5, 1973 · N8858N · Substantial damage NTSB LAX74DUJ35Accident · Minor injuriesClosedCessna 210 · Sedona, AZDec 5, 1973 · N9581T · Substantial damage NTSB FTW74DRJ26Accident · No injuriesClosedPiper PA-23 · Vera Cruz, MexicoDec 5, 1973 · N14348 · Substantial damage NTSB CHI74AC046Accident · Serious injuriesClosedBeech C-45H · Plymouth, MIDec 5, 1973 · N9909Z · Destroyed NTSB NYC74FHA20Accident · No injuriesClosedMooney M20C · Collegeville, PADec 4, 1973 · N6754U · Substantial damage NTSB IAD74FIG16Accident · Serious injuriesClosedCessna 150 · Laurel, MDDec 4, 1973 · N19327 · Substantial damage NTSB FTW74DRG39Accident · No injuriesClosedCessna 172 · Austin, TXDec 4, 1973 · N84148 · Substantial damage NTSB NYC74DFJ19Accident · No injuriesClosedPiper PA-12 · Skaneateles, NYDec 3, 1973 · N2999M · Substantial damage NTSB MKC74FCQ20Accident · Serious injuriesClosedCessna 182 · Manhattan, KSDec 3, 1973 · N21357 · Substantial damage NTSB MIA74FKQ11Accident · Minor injuriesClosedBoeing E75 · Jackson, MSDec 3, 1973 · N131J · Destroyed NTSB MIA74FKG46Accident · Minor injuriesClosedCessna 140 · Savannah, GADec 3, 1973 · N2220N · Substantial damage NTSB FTW74DPG38Accident · Minor injuriesClosedBeech B19 · Oxford, ARDec 3, 1973 · N1962W · Destroyed NTSB FTW74AF040Accident · 1 fatalClosedMitsubishi MU-2B · Coleman, TXDec 3, 1973 · N307MA · Substantial damage