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 DEN78FA033Accident · 1 fatalClosedCessna 152 · Parker, COMar 14, 1978 · N757CP · Destroyed NTSB NYC78FHM10Accident · No injuriesClosedCessna 152 · Spring Valley, NYMar 7, 1978 · N24522 · Substantial damage NTSB CHI78DEV21Accident · No injuriesClosedCessna 152 · Peoria, ILMar 5, 1978 · N25038 · Substantial damage NTSB IAD78DLJ07Accident · No injuriesClosedCessna 152 · Ft.Bragg, NCFeb 23, 1978 · N757QA · Substantial damage NTSB MIA78FLG10Accident · No injuriesClosedCessna 152 · High Falls, SCFeb 19, 1978 · N49799 · Substantial damage NTSB MKC78DCD12Accident · No injuriesClosedCessna 152 · Ankeny, IAFeb 18, 1978 · N24374 · Substantial damage NTSB NYC78DHM09Accident · No injuriesClosedCessna 152 · Fairfield, NJFeb 15, 1978 · N24761 · Substantial damage NTSB DEN78DTC12Accident · No injuriesClosedCessna 152 · Cheyenne, WYFeb 13, 1978 · N25444 · Substantial damage NTSB CHI78FEC14Accident · No injuriesClosedCessna 152 · Fraser, MIFeb 6, 1978 · N24204 · Substantial damage NTSB CHI78FA018Accident · 1 fatalClosedCessna 152 · Ypsilanti, MIJan 31, 1978 · N757PQ · Destroyed NTSB SEA78DYP07Accident · No injuriesClosedCessna 152 · Mead, WAJan 19, 1978 · N25029 · Substantial damage NTSB CHI78DEV13Accident · No injuriesClosedCessna 152 · Mt Vernon, ILJan 17, 1978 · N757UB · Substantial damage NTSB FTW78FRD14Accident · Minor injuriesClosedCessna 152 · Denham Springs, LAJan 15, 1978 · N24229 · Destroyed NTSB MIA78FKT27Accident · No injuriesClosedCessna 152 · Miami, FLJan 12, 1978 · N24886 · Substantial damage NTSB LAX78FA017Accident · 2 fatalClosedCessna 152 · Ojai, CADec 31, 1977 · N24945 · Substantial damage NTSB FTW78FA021Accident · 2 fatalClosedCessna 152 · Teague, TXDec 29, 1977 · N714ZQ · Destroyed NTSB SEA78DYM11Accident · No injuriesClosedCessna 152 · Dayton, ORDec 18, 1977 · N757JM · Substantial damage NTSB SEA78FA013Accident · 1 fatalClosedCessna 152 · Quincy, WADec 16, 1977 · N757TC · Destroyed NTSB DEN78FTE18Accident · No injuriesClosedCessna 152 · Ft.Collins, CODec 13, 1977 · N714ZW · Substantial damage NTSB NYC78DFA07Accident · No injuriesClosedCessna 152 · Keen, NYDec 5, 1977 · N757MH · Substantial damage NTSB MKC78FCQ07Accident · No injuriesClosedCessna 152 · Wilmont, KSNov 19, 1977 · N25057 · Destroyed NTSB MIA78FLD11Accident · No injuriesClosedCessna 152 · Seffner, FLNov 15, 1977 · N757HV · Substantial damage NTSB FTW78DRG14Accident · No injuriesClosedCessna 152 · Port Mansfield, TXNov 13, 1977 · N24534 · Substantial damage NTSB MKC78FCQ01Accident · Minor injuriesClosedCessna 152 · Stafford, KSOct 8, 1977 · N757ZT · Substantial damage NTSB MIA77FA092Accident · 1 fatalClosedCessna 152 · Delray Beach, FLSep 26, 1977 · N24497 · Destroyed NTSB MIA77FKT77Accident · Minor injuriesClosedCessna 150 · Ft Lauderdale, FLSep 17, 1977 · N757BE · Substantial damage NTSB OAK77DVG65Accident · No injuriesClosedCessna 152 · Lakeport, CASep 10, 1977 · N757JY · Substantial damage NTSB MIA77FKT72Accident · Minor injuriesClosedCessna 152 · Naples, FLAug 30, 1977 · N757RL · Substantial damage NTSB LAX77FUQ41Accident · No injuriesClosedCessna 152 · Simi Valley, CAJul 17, 1977 · N757CL · Substantial damage NTSB DEN77DTE64Accident · No injuriesClosedCessna 152 · Akron, COJul 7, 1977 · N757JJ · Substantial damage NTSB CHI77FEK25Accident · Minor injuriesClosedCessna 152 · Columbus, OHJun 22, 1977 · N757AZ · Substantial damage NTSB SEA77DYM35Accident · No injuriesClosedCessna 152 · Pendleton, ORMay 27, 1977 · N714UJ · Substantial damage NTSB CHI76DET27Accident · No injuriesClosedCessna 172I · Kentland, INFeb 12, 1976 · N46182 · Substantial damage NTSB LAX76DVM17Accident · No injuriesClosedCessna 172M · San Luis Obsp, CANov 15, 1975 · N91764 · Substantial damage NTSB CHI73ALQ20Accident · No injuriesClosedCessna 177RG · Lexington, KYFeb 11, 1973 · N1874Q · 2 aircraft · Minor damage NTSB MKC69F0332Accident · No injuriesClosedCessna 210E · Clyde, KSJan 28, 1969 · N4781B · Substantial damage NTSB UNK64X4052Accident · No injuriesClosedCessna 180 · Merced, CASep 19, 1964 · N4622B · Substantial damage NTSB UNK64X1662Accident · No injuriesClosedCessna 195 · Fort Rucker, ALMay 8, 1964 · N64900 · Substantial damage