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 MKC80FER12Accident · No injuriesClosedCessna 152 · Minneapolis, MNNov 24, 1979 · N5461B · Substantial damage NTSB SEA80FYM06Accident · Minor injuriesClosedCessna 152 · Newberg, ORNov 23, 1979 · N67500 · Substantial damage NTSB LAX80FA015Accident · No injuriesClosedCessna 152 · Bakersfield, CANov 18, 1979 · N24906 · 2 aircraft · Substantial damage NTSB LAX80DJA04Accident · No injuriesClosedCessna 152 · Honolulu, HINov 18, 1979 · N89774 · Substantial damage NTSB LAX80DVD01Accident · No injuriesClosedCessna 152 · Santa Rosa, CANov 11, 1979 · N67708 · Substantial damage NTSB MKC80DCG01Accident · Minor injuriesClosedCessna 152 · Warrensburg, MONov 10, 1979 · N69206 · Substantial damage NTSB MIA80DLD08Accident · No injuriesClosedCessna 152 · Cedar Key, FLNov 9, 1979 · N24308 · Substantial damage NTSB NYC80FGM06Accident · No injuriesClosedCessna C152 · Belle Vernon, PANov 7, 1979 · N757RA · Substantial damage NTSB CHI80FEC02Accident · No injuriesClosedCessna 152 · Jackson, MINov 6, 1979 · N68246 · Substantial damage NTSB LAX80DVM05Accident · Minor injuriesClosedCessna 152 · Oceano, CANov 4, 1979 · N757TG · Destroyed NTSB NYC80FA008Accident · 1 fatalClosedCessna 152 · New Bedford, MAOct 31, 1979 · N757ZW · Destroyed NTSB NYC80FGM05Accident · Minor injuriesClosedCessna 152 · Jeannette, PAOct 30, 1979 · N757FN · Substantial damage NTSB MIA80DLD02Accident · No injuriesClosedCessna 152 · Sebastian, FLOct 28, 1979 · N64923 · Destroyed NTSB MIA80DKT09Accident · Minor injuriesClosedCessna 152 · Highland Beach, FLOct 27, 1979 · N89705 · Substantial damage NTSB NYC80FHM01Accident · No injuriesClosedCessna 152 · East Hanover, NJOct 23, 1979 · N65601 · Substantial damage NTSB CHI80FEP04Accident · Minor injuriesClosedCessna 152 · Lake Geneva, WIOct 19, 1979 · N714VN · Substantial damage NTSB LAX80FUD02Accident · No injuriesClosedCessna 152 · Hawthorne, CAOct 17, 1979 · N67522 · Substantial damage NTSB MIA80FKG03Accident · No injuriesClosedCessna 152 · Snellville, GAOct 13, 1979 · N67825 · Substantial damage NTSB LAX80FA007Accident · 2 fatalClosedCessna 152 · Ojai, CAOct 13, 1979 · N49216 · Destroyed NTSB IAD80DLQ03Accident · No injuriesClosedCessna 152 · Bowling Green, KYOct 13, 1979 · N47109 · Substantial damage NTSB NYC80FGM02Accident · No injuriesClosedCessna 152 · Butler, PAOct 6, 1979 · N64932 · Substantial damage NTSB UNK80X0100Accident · 2 fatalClosedCessna 152 · Gainesville, TXOct 1, 1979 · N4739B · Destroyed NTSB LAX80DUJ04Accident · No injuriesClosedCessna 152 · Springerville, AZOct 1, 1979 · N714XW · Substantial damage NTSB CHI80DA003Accident · 1 fatalClosedCessna 152 · Syracuse, INOct 1, 1979 · N89179 · Destroyed NTSB CHI7.FEP81Accident · Minor injuriesClosedCessna 152 · Rio, WISep 28, 1979 · N714SY · Substantial damage NTSB SEA79DYE46Accident · No injuriesClosedCessna 152 · Rochester, WASep 16, 1979 · N68267 · Substantial damage NTSB MKC79DCD40Accident · No injuriesClosedCessna 152 · Oxford, IASep 12, 1979 · N65465 · Substantial damage NTSB FTW79DPA28Accident · No injuriesClosedCessna 152 · Corsicana, TXSep 10, 1979 · N25281 · Substantial damage NTSB CHI79FET30Accident · No injuriesClosedCessna 152 · East Chicago, INSep 9, 1979 · N24489 · Substantial damage NTSB MIA79DLD96Accident · No injuriesClosedCessna 152 · Lutz, FLSep 8, 1979 · N47009 · Substantial damage NTSB SEA79FYK28Accident · No injuriesClosedCessna 152 · Creswell, ORSep 7, 1979 · N89487 · Substantial damage NTSB CHI79DEC53Accident · No injuriesClosedCessna 152 · Detroit, MISep 1, 1979 · N25800 · Substantial damage NTSB CHI79CEM38Accident · No injuriesClosedCessna 150 · Muskegon, MIAug 30, 1979 · N68339 · Substantial damage NTSB MKC79DCD35Accident · No injuriesClosedCessna 152 · Mt Pleasant, IAAug 27, 1979 · N24366 · Substantial damage NTSB DEN79FTE77Accident · Minor injuriesClosedCessna 152 · Center, COAug 27, 1979 · N24967 · Substantial damage NTSB CHI79DEG24Accident · No injuriesClosedCessna 152 · Camden, OHAug 27, 1979 · N46758 · Substantial damage NTSB LAX79FA070Accident · 2 fatalClosedCessna 152 · San Marcos, CAAug 26, 1979 · N48740 · Destroyed NTSB FTW79DPD44Accident · Serious injuriesClosedCessna 152 · Fort Worth, TXAug 23, 1979 · N5139B · Minor damage NTSB NYC79FA081Accident · 1 fatalClosedCessna 152 · Kunkletown, PAAug 19, 1979 · N49080 · Destroyed 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