Skip to content

NTSB investigations · 1,193

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 ('2071816') 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 ('2071816')
  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 ('2071816')
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 LAX76DUM05Accident · No injuriesClosedCessna 150 · Bombay Beach, CASep 14, 1975 · N6302S · Substantial damage NTSB CHI76FEM07Accident · Minor injuriesClosedCessna 150G · Nunica, MIAug 18, 1975 · N2441J · Substantial damage NTSB FTW76DPJ04Accident · No injuriesClosedCessna 150G · Marlow, OKJul 31, 1975 · N3830J · Destroyed NTSB MIA7LFKQ05Accident · Serious injuriesClosedCessna 150G · Okolona, MSJul 28, 1975 · N4050J · Substantial damage NTSB OAK76FVG01Accident · No injuriesClosedCessna 150 · Franklin, CAJul 6, 1975 · N3687J · Substantial damage NTSB SEA7LFTI01Accident · No injuriesClosedCessna 150G · Wise River, MTJul 3, 1975 · N3094S · Substantial damage NTSB MKC75FCA34Accident · Serious injuriesClosedCessna 150 · Poplar Bluff, MOJun 30, 1975 · N3501L · Substantial damage NTSB FTW75DPD51Accident · Minor injuriesClosedCessna 150G · Munday, TXJun 29, 1975 · N4634X · Substantial damage NTSB FTW75DRA34Accident · No injuriesClosedCessna 150 · Trinity, TXJun 21, 1975 · N4668X · Substantial damage NTSB SEA75DYE48Accident · Minor injuriesClosedCessna 150 · Blaine, WAJun 18, 1975 · N8364J · Substantial damage NTSB NYC75DFJ26Accident · No injuriesClosedCessna 150G · Farmington, NYJun 17, 1975 · N8324J · Substantial damage NTSB IAD75FKW19Accident · No injuriesClosedCessna 150 · Crossville, TNJun 16, 1975 · N2676J · Substantial damage NTSB NYC75AN117Accident · 2 fatalClosedCessna 150 · Macungie, PAJun 10, 1975 · N3810J · 2 aircraft · Destroyed NTSB MIA75DLD80Accident · No injuriesClosedCessna 150 · Groveland, FLJun 1, 1975 · N6274S · Substantial damage NTSB IAD75DLJ29Accident · No injuriesClosedCessna 150 · Princeton, NCMay 25, 1975 · N3641J · Substantial damage NTSB IAD75DKM29Accident · Minor injuriesClosedCessna 150 · Marion, NCMay 21, 1975 · N2919J · Substantial damage NTSB LAX75DUJ84Accident · No injuriesClosedCessna 150 · Seligman, AZMay 16, 1975 · N8316J · Substantial damage NTSB CHI75AC083Accident · 1 fatalClosedCessna 150G · Prudenville, MIMay 6, 1975 · N2910S · Substantial damage NTSB LAX7500027Accident · No injuriesClosedCessna 150 · Mexicali, MexicoMay 3, 1975 · N3955J · Substantial damage NTSB CHI75DEG19Accident · No injuriesClosedCessna 150G · Brookville, OHApr 29, 1975 · N4730X · Substantial damage NTSB IAD75DKM25Accident · No injuriesClosedCessna 150G · Wadesboro, NCApr 15, 1975 · N2603J · Substantial damage NTSB NYC75FGT14Accident · No injuriesClosedCessna 150 · University Pk, PAMar 18, 1975 · N904PS · Substantial damage NTSB FTW75FPA20Accident · No injuriesClosedCessna 150 · Terrell, TXFeb 25, 1975 · N8383J · Substantial damage NTSB NYC75FHD35Accident · Minor injuriesClosedCessna 150G · Manahawkin, NJFeb 19, 1975 · N2487J · Destroyed NTSB OAK75AP034Accident · 1 fatalClosedCessna 150G · Tulelake, CAFeb 2, 1975 · N3117J · Destroyed NTSB MIA75AM052Accident · 2 fatalClosedCessna 150J · Vilano Beach, FLFeb 1, 1975 · N2826S · Destroyed NTSB MIA75FKG57Accident · No injuriesClosedCessna 150G · Folkston, GAJan 31, 1975 · N3866J · Destroyed NTSB MIA75DK656Accident · Minor injuriesClosedCessna 150G · Ellijay, GAJan 19, 1975 · N2592Q · Substantial damage NTSB DEN75FQA27Accident · No injuriesClosedCessna 150 · Las Vegas, NMJan 18, 1975 · N8694J · Substantial damage NTSB FTW75FPA16Accident · Serious injuriesClosedCessna 150G · Teague, TXJan 17, 1975 · N8434J · Destroyed NTSB SEA75AS027Accident · 1 fatalClosedCessna 150H · Newberg, ORJan 13, 1975 · N3701J · Destroyed NTSB OAK75FVG42Accident · No injuriesClosedCessna 150 · Chico, CADec 25, 1974 · N3315J · Destroyed NTSB LAX75DUG27Accident · No injuriesClosedCessna 150 · Colton, CADec 7, 1974 · N2623J · Substantial damage NTSB MIA75FKG31Accident · No injuriesClosedCessna 150 · Marietta, GANov 13, 1974 · N8511J · Substantial damage NTSB MKC75FTG15Accident · No injuriesClosedCessna 150 · Devils Lake, NDNov 7, 1974 · N4706X · Substantial damage NTSB LAX75FUA14Accident · No injuriesClosedCessna 150G · Catalina Is, CAOct 24, 1974 · N3754J · Destroyed NTSB LAX75DUQ11Accident · No injuriesClosedCessna 150 · Agua Dulce, CAOct 10, 1974 · N6314S · Substantial damage NTSB NYC75DHD22Accident · No injuriesClosedCessna 150 · Smithville, NJOct 7, 1974 · N3386J · Substantial damage NTSB FTW75FPD09Accident · Minor injuriesClosedCessna 150 · Aledo, TXSep 29, 1974 · N8624J · Substantial damage NTSB MKC75FCG13Accident · No injuriesClosedCessna 150 · Kansas City, KSSep 8, 1974 · N3369J · Substantial damage NTSB OAK75DVG17Accident · Minor injuriesClosedCessna 150G · Martell, CAAug 20, 1974 · N3202X · Destroyed NTSB OAK75DVD07Accident · No injuriesClosedCessna 150 · Lodi, CAAug 20, 1974 · N3213J · Substantial damage NTSB NYC75FNE06Accident · No injuriesClosedCessna 150G · Washington, MAAug 14, 1974 · N3427J · Substantial damage NTSB FTW75DRA02Accident · Serious injuriesClosedCessna 150G · Conroe, TXJul 7, 1974 · N6357S · Substantial damage NTSB NYC74FGM39Accident · 1 fatalClosedCessna 150 · Tarentum, PAJun 18, 1974 · N3058S · Destroyed NTSB MIA74FKG86Accident · Minor injuriesClosedCessna 150G · Williamson, GAJun 16, 1974 · N8588J · Destroyed NTSB MIA74DLG33Accident · No injuriesClosedCessna 150 · Mullins, SCJun 14, 1974 · N6313S · Substantial damage NTSB MIA74FLG28Accident · No injuriesClosedCessna 150G · Charleston, SCMay 23, 1974 · N6364S · Substantial damage NTSB NYC74FNE24Accident · Minor injuriesClosedCessna 150 · Sherman, CTMay 17, 1974 · N8684J · Substantial damage NTSB MIA74DKQ19Accident · No injuriesClosedCessna 150G · Bolton, MSMay 1, 1974 · N3623J · Substantial damage

Back to Cessna 150G