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 MIA67D0410Accident · No injuriesClosedCessna 150G · W.Hollywood, FLFeb 10, 1967 · N4675X · Substantial damage NTSB MIA67D0392Accident · No injuriesClosedCessna 150G · Opa Locka, FLFeb 10, 1967 · N4636X · Substantial damage NTSB NYC67F0497Accident · No injuriesClosedCessna 150 · Tyrone, PAFeb 4, 1967 · N3446J · Destroyed NTSB CHI67D0586Accident · No injuriesClosedCessna 150 · Peoria, ILFeb 4, 1967 · N3829J · Substantial damage NTSB LAX67D0385Accident · No injuriesClosedCessna 150 · 29 Palms, CAFeb 1, 1967 · N3203X · Substantial damage NTSB MIA67D0537Accident · Minor injuriesClosedCessna 150G · Winnsboro, SCJan 28, 1967 · N4095J · Substantial damage NTSB OAK67F0204Accident · No injuriesClosedCessna 150 · Sacramento, CAJan 25, 1967 · N3171X · Substantial damage NTSB MIA67D0384Accident · No injuriesClosedCessna 150 · Orlando, FLJan 25, 1967 · N4627X · Substantial damage NTSB CHI67F0585Accident · No injuriesClosedCessna 150G · Camp Grove, ILJan 23, 1967 · N3621J · Substantial damage NTSB NYC67D0489Accident · No injuriesClosedCessna 150 · Sewell, NJJan 22, 1967 · N3976J · 2 aircraft · Substantial damage NTSB DEN67F0195Accident · No injuriesClosedCessna 150G · Loveland, COJan 21, 1967 · N2224J · Substantial damage NTSB MKC67D0413Accident · No injuriesClosedCessna 150 · Bigg Falls, MNJan 19, 1967 · N3180J · Substantial damage NTSB NYC67F0473Accident · No injuriesClosedCessna 150 · Ronkonkoma, NYJan 18, 1967 · N3689J · Substantial damage NTSB FTW67F0411Accident · Minor injuriesClosedCessna 150 · Jenks, OKJan 15, 1967 · N3635J · Substantial damage NTSB FTW67A0071Accident · 2 fatalClosedCessna 150G · Lawton, OKJan 8, 1967 · N3110J · Destroyed NTSB FTW67D0362Accident · No injuriesClosedCessna 150 · Stillwater, OKJan 1, 1967 · N3920J · Substantial damage NTSB OAK67D0180Accident · No injuriesClosedCessna 150 · Vallejo, CADec 29, 1966 · N4781X · Substantial damage NTSB MIA67D0344Accident · Minor injuriesClosedCessna 150 · Miami, FLDec 28, 1966 · N4709X · Substantial damage NTSB LAX67D0256Accident · No injuriesClosedCessna 150G · Essex, CADec 27, 1966 · N3861J · Substantial damage NTSB MKC67D0370Accident · No injuriesClosedCessna 150F · Alta Vista, IADec 24, 1966 · N2431J · Substantial damage NTSB NYC67D0432Accident · No injuriesClosedCessna 150 · White Plains, NYDec 18, 1966 · N3190X · Substantial damage NTSB MKC67F0420Accident · Minor injuriesClosedCessna 150 · Goddard, KSDec 15, 1966 · N2213J · Substantial damage NTSB MKC67F0422Accident · No injuriesClosedCessna 150G · Manhattan, KSDec 13, 1966 · N3805J · Substantial damage NTSB CHI67F0386Accident · No injuriesClosedCessna 150 · Plymouth, MIDec 11, 1966 · N3178X · Substantial damage NTSB MKC67F0498Accident · No injuriesClosedCessna 150G · Bogue, KSDec 10, 1966 · N3953J · Substantial damage NTSB DEN67D0167Accident · No injuriesClosedCessna 150 · Logmont, CONov 30, 1966 · N3817J · Substantial damage NTSB FTW67D0320Accident · No injuriesClosedCessna 150G · Beaumont, TXNov 29, 1966 · N2463J · Substantial damage NTSB FTW67D0351Accident · Minor injuriesClosedCessna 150 · Dell City, TXNov 24, 1966 · N3657J · Destroyed NTSB MIA67D0332Accident · No injuriesClosedCessna 150G · Melbourne, FLNov 18, 1966 · N3859J · Substantial damage NTSB SEA67D0202Accident · No injuriesClosedCessna 150 · Pasco, WANov 12, 1966 · N3986J · Substantial damage NTSB CHI67F0294Accident · No injuriesClosedCessna 150 · Lewis, INNov 12, 1966 · N3769J · Substantial damage NTSB SEA67D0178Accident · Minor injuriesClosedCessna 150 · Wayan, IDNov 2, 1966 · N4800X · Substantial damage NTSB MKC67D0305Accident · No injuriesClosedCessna 150 · Cheney, KSNov 2, 1966 · N3160X · Substantial damage NTSB OAK67D0117Accident · No injuriesClosedCessna 150G · San Carlos, CAOct 18, 1966 · N3704J · Substantial damage NTSB CHI67F0329Accident · No injuriesClosedCessna 150 · Strongsville, OHOct 12, 1966 · N3683J · Substantial damage NTSB CHI67D0298Accident · No injuriesClosedCessna 150G · Rockford, ILOct 8, 1966 · N3728J · Substantial damage NTSB NYC67D0290Accident · Minor injuriesClosedCessna 150 · Long Valley, NJSep 27, 1966 · N3853J · Destroyed NTSB FTW67D0203Accident · No injuriesClosedCessna 150 · San Augustine, TXSep 16, 1966 · N3659J · Destroyed NTSB CHI67D0273Accident · No injuriesClosedCessna 150 · Middle Bass, OHSep 10, 1966 · N4734X · Destroyed NTSB LAX67F0105Accident · Serious injuriesClosedCessna 150 · Adamana, AZSep 7, 1966 · N3680J · Destroyed NTSB SEA67F0184Accident · Minor injuriesClosedCessna 150 · Springfield, ORSep 5, 1966 · N3690J · Substantial damage NTSB NYC67D0181Accident · No injuriesClosedCessna 150 · Ambler, PAAug 20, 1966 · N3187X · Substantial damage NTSB UNK65X0955Accident · No injuriesClosedCessna 310B · Hopkins, MNDec 8, 1964 · N547M · Substantial damage

Back to Cessna 150G