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 UNK64X3452Accident · No injuriesClosedCessna 150 · Denver, COAug 18, 1964 · N7758E · Substantial damage NTSB UNK64X3398Accident · No injuriesClosedCessna 150 · Frankfort, KSAug 15, 1964 · N5539E · Substantial damage NTSB UNK64X3293Accident · No injuriesClosedCessna 150 · Asbury Park, NJAug 9, 1964 · N5708E · Substantial damage NTSB UNK64X3012Accident · Minor injuriesClosedCessna 150 · Ducktown, TNJul 24, 1964 · N7921E · Destroyed NTSB UNK64X2750Accident · Minor injuriesClosedCessna 150 · Ambler, PAJul 10, 1964 · N7969E · Destroyed NTSB UNK64X2724Accident · No injuriesClosedCessna 150 · Minerva, OHJul 9, 1964 · N7990E · Substantial damage NTSB UNK64X2666Accident · No injuriesClosedCessna 150 · Santa Susana, CAJul 5, 1964 · N7827E · Substantial damage NTSB UNK64X2644Accident · No injuriesClosedCessna 150 · Pacoima, CAJul 4, 1964 · N5668E · Substantial damage NTSB UNK64X2561Accident · 2 fatalClosedCessna 150 · New Richmond, INJun 29, 1964 · N7806E · Destroyed NTSB UNK64X2395Accident · No injuriesClosedCessna 150 · Dayton, OHJun 20, 1964 · N5994E · Substantial damage NTSB UNK64X2291Accident · No injuriesClosedCessna 150 · Roswell, NMJun 14, 1964 · N7790E · Substantial damage NTSB UNK64X2127Accident · No injuriesClosedCessna 150 · Sussex, NJJun 5, 1964 · N5739E · Substantial damage NTSB UNK64X1935Accident · No injuriesClosedCessna 150 · S Branch, MIMay 24, 1964 · N5874E · Substantial damage NTSB UNK64X1892Accident · No injuriesClosedCessna 150D · Aberdeen, OHMay 23, 1964 · N4365U · Substantial damage NTSB UNK64X1883Accident · No injuriesClosedCessna 150 · Northhampton, MAMay 22, 1964 · N6492T · Substantial damage NTSB UNK64X1845Accident · No injuriesClosedCessna 150 · W Carrollton, OHMay 19, 1964 · N7958E · Substantial damage NTSB UNK64X1729Accident · 1 fatalClosedCessna 150 · Gastonia, NCMay 11, 1964 · N7721E · Destroyed NTSB UNK64X1682Accident · No injuriesClosedCessna 150 · Chattanooga, OKMay 9, 1964 · N5965E · Substantial damage NTSB UNK64X1635Accident · No injuriesClosedCessna 150 · Muskegon, MIMay 6, 1964 · N5906E · Substantial damage NTSB UNK64X1598Accident · No injuriesClosedCessna 150 · Clayton, INMay 3, 1964 · N5517E · Substantial damage NTSB UNK64X1455Accident · No injuriesClosedCessna 150 · Milwaukee, WIApr 25, 1964 · N6529T · Substantial damage NTSB UNK64X1309Accident · No injuriesClosedCessna 150 · Auburn, CAApr 14, 1964 · N5510E · Substantial damage NTSB UNK64X1301Accident · No injuriesClosedCessna 150 · Dallas, TXApr 13, 1964 · N5667E · Substantial damage NTSB UNK64X1245Accident · No injuriesClosedCessna 150 · Bishop, CAApr 10, 1964 · N6539T · Substantial damage NTSB UNK64X1205Accident · No injuriesClosedCessna 150 · Vega Baja, PRApr 6, 1964 · N7903E · Substantial damage NTSB UNK64X1007Accident · Minor injuriesClosedCessna 150 · St Joseph, MOMar 21, 1964 · N6548T · Destroyed NTSB UNK64X0961Accident · No injuriesClosedCessna 150 · Pearland, TXMar 17, 1964 · N5864E · Substantial damage NTSB UNK64X0941Accident · No injuriesClosedCessna 150 · Capistrano, CAMar 15, 1964 · N7827E · Substantial damage NTSB UNK64X0840Accident · Serious injuriesClosedCessna 150 · Bristol, VTMar 7, 1964 · N6508T · No damage NTSB UNK64X0748Accident · Minor injuriesClosedCessna 150 · Mouline, ILFeb 29, 1964 · N7933E · Destroyed NTSB UNK64X0689Accident · Minor injuriesClosedCessna 150 · Moorehead, MNFeb 25, 1964 · N7897E · Destroyed NTSB UNK64X0646Accident · No injuriesClosedCessna 150 · Albuquerque, NMFeb 22, 1964 · N4124U · 2 aircraft · Substantial damage NTSB UNK64X0491Accident · No injuriesClosedCessna 150 · Park Hall, MDFeb 8, 1964 · N7009X · Destroyed NTSB UNK64X0463Accident · No injuriesClosedCessna 150 · New Orleans, LAFeb 5, 1964 · N7993E · Substantial damage NTSB UNK64X0422Accident · No injuriesClosedCessna 150 · Ringwood, ILFeb 1, 1964 · N5511E · Substantial damage NTSB UNK64X0391Accident · Minor injuriesClosedCessna 150 · Elk River, MNJan 28, 1964 · N5755E · Substantial damage NTSB UNK64X0229Accident · No injuriesClosedCessna 150 · Rosemont, MNJan 12, 1964 · N5828E · Substantial damage NTSB UNK64X0217Accident · No injuriesClosedCessna 150 · Fresno, CAJan 11, 1964 · N7729E · Substantial damage NTSB UNK64X0148Accident · No injuriesClosedCessna 150 · Bennett, COJan 4, 1964 · N7930E · Substantial damage

Back to Cessna 150