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 LAX80DVD05Accident · No injuriesClosedCessna 152 · Santa Rosa, CADec 14, 1979 · N5085B · Substantial damage NTSB MIA80DLA11Accident · Minor injuriesClosedCessna 152 · Tallahassee, FLDec 13, 1979 · N24243 · Substantial damage NTSB NYC80DHD08Accident · No injuriesClosedCessna 152 · Toms River, NJDec 11, 1979 · N48470 · Substantial damage NTSB FTW80FRA12Accident · No injuriesClosedCessna 152 · Eagle Lake, TXDec 7, 1979 · N49190 · Destroyed NTSB MKC80DCG05Accident · No injuriesClosedCessna 152 · Lee'S Summit, MODec 6, 1979 · N24547 · Substantial damage NTSB MKC80DER14Accident · No injuriesClosedCessna 152 · Jackson, MNDec 4, 1979 · N24374 · Substantial damage NTSB LAX80DUJ19Accident · Minor injuriesClosedCessna 152 · Phoenix, AZDec 3, 1979 · N25763 · Destroyed NTSB SEA80FYE09Accident · Serious injuriesClosedCessna 152 · Freeland, WADec 1, 1979 · N48129 · Substantial damage NTSB FTW80FPM05Accident · No injuriesClosedCessna 152 · Tulsa, OKDec 1, 1979 · N25475 · Substantial damage NTSB CHI80FEP07Accident · Minor injuriesClosedCessna 152 · Madison, WINov 29, 1979 · N714WL · Substantial damage NTSB LAX80FA021Accident · 2 fatalClosedCessna 152 · Flagstaff, AZNov 27, 1979 · N48835 · Destroyed 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

Back to Cessna 152