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 NYC74AN060Accident · Serious injuriesClosedDouglas DC-9 · Lebanon, NHDec 21, 1973 · N3338L · No damage NTSB NYC74AN058Accident · 2 fatalClosedCessna 177RG · Dravosburg, PADec 21, 1973 · N77RG · Destroyed NTSB NYC74AN057Accident · Serious injuriesClosedCessna 411 · Endicott, NYDec 21, 1973 · N424RF · Destroyed NTSB MKC74FER30Accident · No injuriesClosedBell 47G4A · St Paul, MNDec 21, 1973 · N2247W · Substantial damage NTSB MKC74FER29Accident · No injuriesClosedBrantly B2 · Rosemount, MNDec 21, 1973 · N5920X · Substantial damage NTSB MIA74DLD48Accident · No injuriesClosedCessna 172 · St Petersburg, FLDec 21, 1973 · N46466 · Substantial damage NTSB MIA74DKJ38Accident · No injuriesClosedBeech B95 · Birmingham, ALDec 21, 1973 · N2710Y · Substantial damage NTSB MIA74DKJ37Accident · No injuriesClosedCessna 182 · Hazel Green, ALDec 21, 1973 · N3186Y · Substantial damage NTSB DEN74DTE50Accident · No injuriesClosedCessna 182 · Ft.Lupton, CODec 21, 1973 · N21053 · Substantial damage NTSB CHI74DEM31Accident · No injuriesClosedCessna 150 · Ludington, MIDec 21, 1973 · N6491F · Substantial damage NTSB CHI74DEC23Accident · No injuriesClosedCessna 150 · Troy, MIDec 21, 1973 · N6463S · Substantial damage NTSB NYC74IN055Incident · 1 fatalClosedBoeing 727 · Syracuse, NYDec 20, 1973 · N964 · No damage NTSB NYC74FHJ17Accident · Serious injuriesClosedHiller Acft FH1100 · Bethpage, NYDec 20, 1973 · N609PD · Substantial damage NTSB NYC74AN056Accident · 2 fatalClosedBeech 95-B55 · Colonie, NYDec 20, 1973 · N5729K · Destroyed NTSB MKC74DER27Accident · No injuriesClosedPiper J-3 · Aitkin, MNDec 20, 1973 · N3322N · Substantial damage NTSB MIA74AM054Accident · 3 fatalClosedLake L4-200 · Bimini, Burkina FasoDec 20, 1973 · N39385 · Destroyed NTSB MIA74AM049Accident · 2 fatalClosedBeech C90 · W Columbia, SCDec 20, 1973 · N711FC · Destroyed NTSB LAX74AL045Accident · 2 fatalClosedCessna A150L · Lucerne Vly, CADec 20, 1973 · N6043J · Destroyed NTSB LAX74AL044Accident · 2 fatalClosedPiper PA-28 · Corona, CADec 20, 1973 · N5382W · Substantial damage NTSB IAD74FHD23Accident · No injuriesClosedPiper PA-24 · Wilmington, DEDec 20, 1973 · N8476P · Substantial damage NTSB FTW74AF045Accident · Serious injuriesClosedBeech C-45H · Waco, TXDec 20, 1973 · N2122 · Destroyed NTSB CHI74DEE43Accident · No injuriesClosedStinson 108 · Kewanee, ILDec 20, 1973 · N8546K · Substantial damage NTSB CHI74DEE40Accident · No injuriesClosedCessna 150 · Rochelle, ILDec 20, 1973 · N10488 · Substantial damage NTSB ANC74FAA24Accident · No injuriesClosedConvair L-13 · Fairbanks, AKDec 20, 1973 · N4704V · Substantial damage NTSB ANC74DAG82Accident · No injuriesClosedChampion 7GCBC · Kodiak, AKDec 20, 1973 · N9018L · Substantial damage NTSB SEA74DYC29Accident · No injuriesClosedCessna 172L · La Grande, ORDec 19, 1973 · N7251Q · Substantial damage NTSB OAK74AP023Accident · 2 fatalClosedPiper PA-22 · Concord, CADec 19, 1973 · N8245C · Destroyed NTSB NYC74IN054Incident · No injuriesClosedBeech E18S · Windsor Lock, CTDec 19, 1973 · N111EH · Minor damage NTSB MKC74DER28Accident · No injuriesClosedBeech E58 · T River Fall, MNDec 19, 1973 · N6AC · Substantial damage NTSB MIA74FLG17Accident · No injuriesClosedPiper PA-28R · Winnsboro, SCDec 19, 1973 · N16361 · Substantial damage NTSB MIA74FKA06Accident · Minor injuriesClosedCessna 177 · St Thomas, VIDec 19, 1973 · N2229Y · Substantial damage NTSB IAD74DKM28Accident · No injuriesClosedPiper PA-28R · Greensboro, NCDec 19, 1973 · N3951T · Substantial damage NTSB DEN74FTM09Accident · No injuriesClosedCessna 172D · West Jordan, UTDec 19, 1973 · N2651U · Substantial damage NTSB CHI74AC051Accident · 2 fatalClosedBeech 95-C55 · Rochester, INDec 19, 1973 · N6299V · Destroyed NTSB CHI74AC050Accident · No injuriesClosedGates Lear 25 · Detroit, MIDec 19, 1973 · N360AA · Substantial damage NTSB OAK74DXQ18Accident · No injuriesClosedCessna 150 · Chester, CADec 18, 1973 · N51135 · Substantial damage NTSB OAK74DVG28Accident · No injuriesClosedBoeing A75N1 · Woodland, CADec 18, 1973 · N56225 · Substantial damage NTSB OAK74DVD18Accident · No injuriesClosedCessna 172 · Novato, CADec 18, 1973 · N19886 · Substantial damage NTSB MKC74DCG16Accident · No injuriesClosedCessna 150L · Pleasanton, KSDec 18, 1973 · N18640 · Substantial damage NTSB MKC74AK033Accident · 2 fatalClosedCessna 310L · Manhattan, KSDec 18, 1973 · N3269X · Destroyed NTSB MIA74D5T43Accident · No injuriesClosedMaule M4-220 · Ft Lauderdale, FLDec 18, 1973 · N2034U · Substantial damage NTSB LAX74FUM15Accident · No injuriesClosedCessna 310D · San Diego, CADec 18, 1973 · N488SS · Substantial damage NTSB FTW74AF044Accident · 2 fatalClosedPiper PA-23 · Weatherford, OKDec 18, 1973 · N14099 · Destroyed NTSB DEN74FQG02Accident · No injuriesClosedCessna TU206F · Jal, NMDec 18, 1973 · N51404 · Substantial damage NTSB UNK74X0101Incident · 31 fatalClosedBoeing 707 · Rome, ItalyDec 17, 1973 · N407PA · Destroyed NTSB SEA74DYA17Accident · No injuriesClosedBell 47G-3B · Twin Falls, IDDec 17, 1973 · N8588F · Substantial damage NTSB OAK74DVA38Accident · No injuriesClosedBoeing A75N1 · Hanford, CADec 17, 1973 · N4768V · Substantial damage NTSB NYC74FHJ18Accident · No injuriesClosedLear Jet 25 · White Plains, NYDec 17, 1973 · N900P · Substantial damage NTSB MIA74DKJ36Accident · No injuriesClosedCessna 207 · Troy, ALDec 17, 1973 · N91061 · Substantial damage NTSB LAX74FUA14Accident · No injuriesClosedCessna 182 · Torrance, CADec 17, 1973 · N2415Q · Substantial damage