Skip to content

NTSB investigations · 1,320

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 ('2071602', '2071603') 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 ('2071602', '2071603')
  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 ('2071602', '2071603')
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 OAK65F0008Accident · No injuriesClosedCessna 140 · San Jose, CAFeb 5, 1965 · N2095N · 2 aircraft · Substantial damage NTSB UNK65X1393Accident · No injuriesClosedCessna 140 · Winchester, VAFeb 4, 1965 · N76511 · Substantial damage NTSB CHI65F0046Accident · No injuriesClosedCessna 140 · Woodburn, INJan 30, 1965 · N1992V · Substantial damage NTSB NYC65F0045Accident · No injuriesClosedCessna 140 · Rochester, NHJan 28, 1965 · N2440N · Substantial damage NTSB UNK65X1336Accident · No injuriesClosedCessna 140 · Ft Lauderdale, FLJan 24, 1965 · N2740N · Substantial damage NTSB LAX65D0059Accident · No injuriesClosedCessna 140 · Santa Ana, CAJan 24, 1965 · N76283 · Substantial damage NTSB UNK65X1323Accident · No injuriesClosedCessna 120 · Jacksonville, FLJan 20, 1965 · N4127N · Destroyed NTSB UNK65X1305Accident · Minor injuriesClosedCessna 140 · Nashua, NHJan 17, 1965 · N72369 · 2 aircraft · Destroyed NTSB LAX65F0007Accident · No injuriesClosedCessna 140 · San Fernando, CAJan 17, 1965 · N89952 · Destroyed NTSB UNK65X1269Accident · No injuriesClosedCessna 140 · Sebastian, FLJan 10, 1965 · N89124 · Substantial damage NTSB UNK65X1256Accident · No injuriesClosedCessna 140 · Orange, VAJan 9, 1965 · N76841 · Substantial damage NTSB UNK65X1216Accident · No injuriesClosedCessna 140 · Millbury, MAJan 2, 1965 · N90136 · Substantial damage NTSB UNK65X1110Accident · No injuriesClosedCessna 140 · Inyokern, CADec 24, 1964 · N76736 · Substantial damage NTSB UNK65X1074Accident · No injuriesClosedCessna 140 · Bonner Springs, KSDec 20, 1964 · N89799 · Substantial damage NTSB UNK65X1065Accident · 2 fatalClosedCessna 140 · Oak Brook, ILDec 19, 1964 · N72353 · Destroyed NTSB UNK65X0929Accident · 2 fatalClosedCessna 140 · New Smyrna Be, FLDec 5, 1964 · N81089 · Destroyed NTSB UNK65X0848Accident · No injuriesClosedCessna 140 · Vero Beach, FLNov 26, 1964 · N89208 · Substantial damage NTSB UNK65X0835Accident · No injuriesClosedCessna 140 · Longmont, CONov 25, 1964 · N2895N · Substantial damage NTSB UNK65X0786Accident · No injuriesClosedCessna 182 · San Carlos, CANov 22, 1964 · N3751V · No damage NTSB UNK65X0577Accident · Minor injuriesClosedCessna 140 · Palm Beach Gd, FLNov 6, 1964 · N76035 · Substantial damage NTSB UNK65X0551Accident · No injuriesClosedCessna 140 · Farmington, MONov 4, 1964 · N2459N · Substantial damage NTSB UNK65X0518Accident · No injuriesClosedCessna 140 · Sparrevohn, AKNov 1, 1964 · N72770 · Substantial damage NTSB UNK65X0517Accident · No injuriesClosedCessna 140 · San Jose, CANov 1, 1964 · N2207N · Substantial damage NTSB UNK65X0347Accident · No injuriesClosedCessna 140 · Horn Lake, MSOct 20, 1964 · N2274N · Substantial damage NTSB UNK65X0329Accident · No injuriesClosedCessna 140 · Houghton, MIOct 18, 1964 · N72856 · Substantial damage NTSB UNK65X0295Accident · No injuriesClosedCessna 140 · Edgely, NDOct 16, 1964 · N72307 · Substantial damage NTSB UNK65X0242Accident · No injuriesClosedCessna 140 · Palmyra, WIOct 11, 1964 · N2050V · Destroyed NTSB UNK65X0204Accident · No injuriesClosedCessna 140 · Lake Berryess, CAOct 9, 1964 · N72458 · Substantial damage NTSB UNK65X0196Accident · No injuriesClosedCessna 140 · Slate Run, PAOct 8, 1964 · N89012 · Destroyed NTSB UNK65X0186Accident · No injuriesClosedCessna 140 · Camas, WAOct 7, 1964 · N76645 · No damage NTSB UNK65X0151Accident · Serious injuriesClosedCessna 140 · Beaverton, OROct 4, 1964 · N2291N · Substantial damage NTSB UNK65X0140Accident · No injuriesClosedCessna 140 · Saugus, CAOct 4, 1964 · N72351 · Destroyed NTSB UNK64X4183Accident · No injuriesClosedCessna 140 · Ames, IASep 27, 1964 · N77075 · Destroyed NTSB UNK64X3973Accident · No injuriesClosedCessna 140 · Rosemount, MNSep 13, 1964 · N72393 · Substantial damage NTSB UNK64X3970Accident · No injuriesClosedCessna 140 · Amarillo, TXSep 13, 1964 · N72807 · Destroyed NTSB UNK64X3942Accident · No injuriesClosedCessna 140 · Bloom, KSSep 12, 1964 · N1806V · Substantial damage NTSB UNK64X3931Accident · 1 fatalClosedCessna 140 · Darien, GASep 12, 1964 · N76246 · Substantial damage NTSB UNK64X3918Accident · No injuriesClosedCessna 140 · Chicago, ILSep 11, 1964 · N89049 · Substantial damage NTSB UNK64X3885Accident · No injuriesClosedCessna 140 · El Reno, OKSep 9, 1964 · N2228V · Substantial damage NTSB UNK64X3869Accident · Minor injuriesClosedCessna 140 · Mt Pleasant, PASep 8, 1964 · N140FC · Substantial damage NTSB UNK64X3825Accident · No injuriesClosedCessna 140 · Burnet, TXSep 6, 1964 · N2340V · Substantial damage NTSB UNK64X3727Accident · No injuriesClosedCessna 140 · Northbrook, ILSep 1, 1964 · N89918 · Substantial damage NTSB UNK64X3686Accident · No injuriesClosedCessna 140 · Greely, COAug 30, 1964 · N89408 · Substantial damage NTSB UNK64X3664Accident · No injuriesClosedCessna 140 · Gualala, CAAug 29, 1964 · N76587 · Substantial damage NTSB UNK64X3659Accident · No injuriesClosedCessna 140 · Birmingham, MIAug 29, 1964 · N2981N · Substantial damage NTSB UNK64X3572Accident · No injuriesClosedCessna 140 · Tacoma, WAAug 24, 1964 · N3624V · Substantial damage NTSB UNK64X3561Accident · No injuriesClosedCessna 140 · San Diego, CAAug 23, 1964 · N2927N · Minor damage NTSB UNK64X3537Accident · No injuriesClosedCessna 140 · Bridgewater, VAAug 22, 1964 · N72134 · Substantial damage NTSB UNK64X3488Accident · No injuriesClosedCessna 140 · Mesa, AZAug 20, 1964 · N1915V · Substantial damage NTSB UNK64X3476Accident · No injuriesClosedCessna 140 · Nacogdoches, TXAug 19, 1964 · N4131N · Substantial damage

Back to Cessna 140