Skip to content

NTSB investigations · 2,749

Matched to the registry by N-number and event date, 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.aircraft_model_code IN ('2071835') 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.aircraft_model_code IN ('2071835')
  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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('2071835')
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 MIA79DLA44Accident · No injuriesClosedCessna 152 · Nashville, GAAug 19, 1979 · N89803 · Substantial damage NTSB NYC79FA078Accident · No injuriesClosedCessna 152 · Islip, NYAug 16, 1979 · N216DV · Substantial damage NTSB MKC79DCQ42Accident · No injuriesClosedCessna 152 · Clements, KSAug 11, 1979 · N89876 · Substantial damage NTSB DEN79DQA45Accident · Serious injuriesClosedCessna 152 · Crown Point, NMAug 8, 1979 · N68705 · Substantial damage NTSB FTW79FPA24Accident · No injuriesClosedCessna 152 · Dallas, TXAug 7, 1979 · N89574 · Substantial damage NTSB DEN79FTE69Accident · No injuriesClosedCessna 152 · Englewood, COAug 1, 1979 · N757JG · Substantial damage NTSB FTW79FPD32Accident · Minor injuriesClosedCessna 152 · Arlington, TXJul 31, 1979 · N69103 · Substantial damage NTSB MKC79DER59Accident · No injuriesClosedCessna 152 · Brainerd, MNJul 28, 1979 · N757ZV · Substantial damage NTSB FTW79DRG50Accident · No injuriesClosedCessna 152 · Westlaco, TXJul 22, 1979 · N49818 · Substantial damage NTSB MIA79DKT80Accident · No injuriesClosedCessna 152 · Lake Park, FLJul 19, 1979 · N757NY · Substantial damage NTSB CHI79FEI32Accident · No injuriesClosedCessna 152 · Akron, OHJul 9, 1979 · N24218 · Substantial damage NTSB CHI79DEE80Accident · No injuriesClosedCessna 152 · Dwight, ILJul 8, 1979 · N714ZY · Destroyed NTSB OAK79FVM29Accident · No injuriesClosedCessna 152 · San Jose, CAJul 6, 1979 · N24455 · Substantial damage NTSB CHI79DEG19Accident · No injuriesClosedCessna 152 · Piqua, OHJul 5, 1979 · N25937 · Substantial damage NTSB NYC79FGM31Accident · No injuriesClosedCessna 152 · West Mifflin, PAJul 3, 1979 · N757VT · Substantial damage NTSB FTW79DRA33Accident · Minor injuriesClosedCessna 152 · Beaumont, TXJul 1, 1979 · N89215 · Substantial damage NTSB MKC79DCQ36Accident · Serious injuriesClosedCessna 152 · Arkansas City, KSJun 27, 1979 · N89142 · Destroyed NTSB MIA79DKT78Accident · No injuriesClosedCessna 152 · Opa Locka, FLJun 27, 1979 · N757ML · Substantial damage NTSB SEA79FYP30Accident · Minor injuriesClosedCessna 152 · Malaga, WAJun 26, 1979 · N757JM · Substantial damage NTSB FTW79DPJ25Accident · No injuriesClosedCessna 152 · Lawton, OKJun 23, 1979 · N47053 · Substantial damage NTSB NYC79FNE17Accident · Minor injuriesClosedCessna 152 · Bristol, CTJun 20, 1979 · N49009 · Substantial damage NTSB LAX79FUA13Accident · No injuriesClosedCessna 152 · Torrance, CAJun 17, 1979 · N24285 · Substantial damage NTSB OAK79DVW17Accident · No injuriesClosedCessna 152 · Panacca, NVJun 13, 1979 · N24233 · Substantial damage NTSB NYC79FHJ16Accident · No injuriesClosedCessna 152 · Farmingdale, NYJun 10, 1979 · N757WN · Substantial damage NTSB MKC79FTK17Accident · No injuriesClosedCessna 152 · Delmont, SDJun 10, 1979 · N65583 · Substantial damage NTSB FTW79DPD21Accident · No injuriesClosedCessna 152 · Keller, TXJun 5, 1979 · N68333 · Substantial damage NTSB FTW79DRG38Accident · No injuriesClosedCessna 152 · Austin, TXJun 2, 1979 · N48857 · Destroyed NTSB CHI79DEG15Accident · No injuriesClosedCessna 152 · Miamisburg, OHMay 30, 1979 · N67310 · Substantial damage NTSB MIA79FA087Accident · 2 fatalClosedCessna 152 · Greenville, MSMay 21, 1979 · N25356 · Destroyed NTSB IAD79FID17Accident · No injuriesClosedCessna 152 · Walkerton, VAMay 16, 1979 · N757YV · Substantial damage NTSB DEN79FTE33Accident · No injuriesClosedCessna 152 · Broomfield, COMay 12, 1979 · N65440 · Substantial damage NTSB SEA79FYP18Accident · No injuriesClosedCessna 152 · Cashmere, WAMay 7, 1979 · N24887 · Substantial damage NTSB FTW79FPG34Accident · No injuriesClosedCessna 152 · Magnolia, ARMay 7, 1979 · N757RG · Substantial damage NTSB CHI79FEV19Accident · No injuriesClosedCessna 152 · Gillespie, ILMay 6, 1979 · N68341 · Substantial damage NTSB CHI79FEC24Accident · No injuriesClosedCessna 152 · Fraser, MIMay 6, 1979 · N69191 · Substantial damage NTSB LAX79DUJ69Accident · No injuriesClosedCessna 152 · Mesa, AZMay 3, 1979 · N24527 · Substantial damage NTSB LAX79FUA12Accident · Minor injuriesClosedCessna 152 · Long Beach, CAMay 2, 1979 · N67770 · Substantial damage NTSB FTW79DQG34Accident · No injuriesClosedCessna 150 · Spur, TXApr 29, 1979 · N24230 · Substantial damage NTSB FTW79DQG32Accident · No injuriesClosedCessna 152 · Hereford, TXApr 27, 1979 · N64987 · Substantial damage NTSB SEA79FYM29Accident · Minor injuriesClosedCessna 152 · Independence, ORApr 26, 1979 · N25790 · Substantial damage NTSB MIA79DLG21Accident · No injuriesClosedCessna 152 · Williamton, SCApr 23, 1979 · N25833 · Substantial damage NTSB NYC79FA039Accident · 2 fatalClosedCessna 152 · Stormville, NYApr 18, 1979 · N67451 · Substantial damage NTSB CHI79FEM19Accident · No injuriesClosedCessna 152 · Negaunee, MIApr 18, 1979 · N24993 · Substantial damage NTSB MKC79DCG37Accident · No injuriesClosedCessna 152 · Olathe, KSApr 9, 1979 · N67845 · Substantial damage NTSB OAK79FVD19Accident · Minor injuriesClosedCessna 152 · Sunol, CAApr 7, 1979 · N25422 · Destroyed NTSB FTW79DRJ12Accident · No injuriesClosedCessna 152 · Alto, LAApr 6, 1979 · N24506 · Substantial damage NTSB MIA79FKG29Accident · No injuriesClosedCessna 152 · Cobbtown, GAApr 5, 1979 · N49155 · Substantial damage NTSB FTW79DRA14Accident · Minor injuriesClosedCessna 152 · Houston, TXApr 4, 1979 · N67650 · Substantial damage NTSB FTW79DPA13Accident · No injuriesClosedCessna 152 · Mesquite, TXMar 24, 1979 · N49431 · Substantial damage NTSB MKC79FER31Accident · No injuriesClosedCessna 152 · Eden Prairie, MNMar 21, 1979 · N65572 · Substantial damage

Back to Cessna 152