Skip to content

NTSB investigations · 489

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 ('2071802') 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 ('2071802')
  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 ('2071802')
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 FTW66F0303Accident · No injuriesClosedCessna 150 · Mena, ARAug 31, 1965 · N7908E · Substantial damage NTSB SEA66D0101Accident · Minor injuriesClosedCessna 150 · Dalkena, WAAug 21, 1965 · N6420T · Substantial damage NTSB MKC66F0145Accident · No injuriesClosedCessna 150 · Montrose, MOAug 9, 1965 · N7943E · Substantial damage NTSB FTW66F0196Accident · Minor injuriesClosedCessna 150 · El Paso, TXAug 9, 1965 · N5831E · Substantial damage NTSB NYC66F0046Accident · No injuriesClosedCessna 150 · Whitehouse, NJJul 6, 1965 · N5708E · Substantial damage NTSB FTW66D0115Accident · No injuriesClosedCessna 150 · Merit, TXJun 25, 1965 · N7762E · Substantial damage NTSB CHI66D0067Accident · No injuriesClosedCessna 150 · Chagrinfalls, OHJun 19, 1965 · N5698E · 2 aircraft · Substantial damage NTSB DEN65A0081Accident · 1 fatalClosedCessna 150D · Byers, COJun 15, 1965 · N4197U · Destroyed NTSB MKC66D0026Accident · No injuriesClosedCessna 150 · Michigan, NDMay 22, 1965 · N6520T · Substantial damage NTSB MIA65F0058Accident · No injuriesClosedCessna 150 · Crystal Sprgs, FLApr 26, 1965 · N5676E · Destroyed NTSB MIA65D0059Accident · No injuriesClosedCessna 150 · Miami, FLApr 22, 1965 · N5518E · Substantial damage NTSB MKC65F0145Accident · No injuriesClosedCessna 150 · Hopkins, MNApr 7, 1965 · N5529E · Substantial damage NTSB CHI65D0045Accident · No injuriesClosedCessna 150 · Arrollton, KYMar 12, 1965 · N5738E · Substantial damage NTSB NYC65F0083Accident · No injuriesClosedCessna 150 · Stratford, NHMar 9, 1965 · N6567T · Substantial damage NTSB FTW66F0133Accident · No injuriesClosedCessna 150 · Sapula, OKMar 9, 1965 · N5598E · Substantial damage NTSB NYC65D0128Accident · No injuriesClosedCessna 150D · Millville, NJMar 3, 1965 · N4143U · Substantial damage NTSB SEA65F0062Accident · No injuriesClosedCessna 150 · Mulino, ORFeb 28, 1965 · N7970E · Substantial damage NTSB LAX65F0019Accident · Serious injuriesClosedCessna 150 · Santa Paula, CAFeb 27, 1965 · N4588U · Destroyed NTSB NYC65F0087Accident · No injuriesClosedCessna 150 · Nedrow, NYFeb 23, 1965 · N7793E · Substantial damage NTSB LAX65F0013Accident · No injuriesClosedCessna 150 · Newhall, CAFeb 20, 1965 · N4382U · Substantial damage NTSB CHI65F0019Accident · No injuriesClosedCessna 150 · Worthington, OHFeb 20, 1965 · N16086 · Substantial damage NTSB UNK65X1418Accident · No injuriesClosedCessna 150 · Buford, GAFeb 13, 1965 · N5696E · Destroyed NTSB UNK65X1406Accident · Serious injuriesClosedCessna 150 · Pearland, TXFeb 7, 1965 · N7779E · Destroyed NTSB NYC65F0039Accident · No injuriesClosedCessna 150 · Hanover, NJJan 31, 1965 · N6504T · Substantial damage NTSB CHI65D0025Accident · No injuriesClosedCessna 150 · New Holstein, WIJan 31, 1965 · N7910E · Substantial damage NTSB UNK65X1308Accident · No injuriesClosedCessna 150 · Fabens, TXJan 18, 1965 · N5576E · Substantial damage NTSB OAK65A0050Accident · 1 fatalClosedCessna 150 · Caruthers, CAJan 10, 1965 · N5851E · Destroyed NTSB UNK65X1252Accident · No injuriesClosedCessna 150 · Ellensburg, WAJan 8, 1965 · N7718E · Substantial damage NTSB UNK65X1159Accident · No injuriesClosedCessna 150 · Cushing, OKDec 27, 1964 · N5779E · Substantial damage NTSB UNK65X1075Accident · 1 fatalClosedCessna 150 · Odessa, TXDec 20, 1964 · N5966E · Destroyed NTSB UNK65X1056Accident · No injuriesClosedCessna 150 · San Carlos, CADec 19, 1964 · N5973E · 2 aircraft · Substantial damage NTSB UNK65X1007Accident · 1 fatalClosedCessna 150 · Anaheim, CADec 13, 1964 · N4124U · 2 aircraft · Destroyed NTSB UNK65X0965Accident · No injuriesClosedCessna 150 · Lima, OHDec 10, 1964 · N5879E · Substantial damage NTSB UNK65X0953Accident · No injuriesClosedCessna 150 · Ypsilanti, MIDec 8, 1964 · N5673E · Substantial damage NTSB UNK65X0882Accident · No injuriesClosedCessna 150 · San Bernardino, CANov 29, 1964 · N7965E · Substantial damage NTSB UNK65X0798Accident · No injuriesClosedCessna 150 · Agawam, MANov 22, 1964 · N5889E · Substantial damage NTSB UNK65X0589Accident · No injuriesClosedCessna 150 · Hopewell Jct, NYNov 7, 1964 · N5621E · Destroyed NTSB UNK65X0532Accident · No injuriesClosedCessna 150 · Hawthorne, CANov 2, 1964 · N7771E · Substantial damage NTSB UNK65X0474Accident · Minor injuriesClosedCessna 150 · Medical Lake, WAOct 29, 1964 · N7942E · Destroyed NTSB UNK65X0459Accident · No injuriesClosedCessna 150 · Colts Neck, NJOct 28, 1964 · N5990E · Substantial damage NTSB UNK65X0435Accident · No injuriesClosedCessna 150 · Clarion, PAOct 25, 1964 · N7766E · Substantial damage NTSB UNK65X0414Accident · 2 fatalClosedCessna 150 · Fort Collins, COOct 24, 1964 · N7869E · Destroyed NTSB UNK65X0221Accident · No injuriesClosedCessna 150 · Hanson, MAOct 10, 1964 · N7728E · Substantial damage NTSB UNK65X0154Accident · No injuriesClosedCessna 150 · Allentown, PAOct 5, 1964 · N6560T · Substantial damage NTSB UNK64X4009Accident · No injuriesClosedCessna 150 · Hanover, NJSep 16, 1964 · N7791E · Substantial damage NTSB UNK64X3845Accident · No injuriesClosedCessna 150 · Bayport, NYSep 7, 1964 · N1298Y · Destroyed NTSB UNK64X3679Accident · 1 fatalClosedCessna 150 · Renton, WAAug 29, 1964 · N516RA · Destroyed NTSB UNK64X3571Accident · No injuriesClosedCessna 150 · Lacombe, LAAug 23, 1964 · N377E · No damage NTSB UNK64X3567Accident · 2 fatalClosedCessna 150 · Fillmore, CAAug 23, 1964 · N139SF · Destroyed NTSB UNK64X3496Accident · No injuriesClosedCessna 150 · Waynesboro, VAAug 20, 1964 · N7318X · Destroyed

Back to Cessna 150