Skip to content

NTSB investigations: Cessna 152

2,738 cases on aircraft the registry lists as Cessna 152. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.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_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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.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_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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.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 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 NTSB NYC79FHJ06Accident · No injuriesClosedCessna 152 · Farmingdale, NYMar 18, 1979 · N25446 · Substantial damage NTSB MIA79DKT66Accident · No injuriesClosedCessna 152 · Ochopee, FLMar 18, 1979 · N49967 · Substantial damage NTSB LAX79FUJ57Accident · No injuriesClosedCessna 152 · Phoenix, AZMar 14, 1979 · N67700 · Substantial damage NTSB SEA79FYE17Accident · No injuriesClosedCessna 152 · Seattle, WAMar 8, 1979 · N24353 · 2 aircraft · Substantial damage NTSB CHI79DET20Accident · No injuriesClosedCessna 152 · Berrien Sprgs, MIMar 6, 1979 · N25389 · Substantial damage NTSB MKC79DER28Accident · No injuriesClosedCessna 152 · Blaine, MNFeb 28, 1979 · N48863 · Substantial damage NTSB CHI79DEP32Accident · No injuriesClosedCessna 152 · Eau Claire, WIFeb 26, 1979 · N89048 · Substantial damage NTSB CHI79DEP30Accident · No injuriesClosedCessna 152 · Hartford, WIFeb 19, 1979 · N757PG · Substantial damage NTSB NYC79FHA10Accident · No injuriesClosedCessna 152 · Slatington, PAFeb 18, 1979 · N49080 · Substantial damage NTSB LAX79FUA05Accident · Serious injuriesClosedCessna 152 · Redondo Beach, CAFeb 11, 1979 · N24490 · Destroyed NTSB OAK79FJA07Accident · Serious injuriesClosedCessna 152 · Pearl Harbor, HIFeb 7, 1979 · N25034 · Destroyed