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 MKC68D0551Accident · No injuriesClosedCessna 140 · Arkansas Cty, KSMay 15, 1968 · N3694V · Substantial damage NTSB MIA69D0089Accident · No injuriesClosedCessna 140 · Irwinville, GAMay 11, 1968 · N72586 · Substantial damage NTSB LAX68D0411Accident · No injuriesClosedCessna 140 · Oxnard, CAMay 10, 1968 · N89891 · Substantial damage NTSB DIA68D0221Accident · No injuriesClosedCessna 140 · Woodbridge, VAMay 8, 1968 · N73019 · Substantial damage NTSB CHI69F0049Accident · No injuriesClosedCessna 140 · Columbia, ILMay 8, 1968 · N2776N · Substantial damage NTSB OAK68D0363Accident · No injuriesClosedCessna 140 · Palo Alto, CAMay 5, 1968 · N89057 · Substantial damage NTSB FTW68D0581Accident · No injuriesClosedCessna 140 · Clinton, ARMay 4, 1968 · N89323 · Substantial damage NTSB NYC68F0470Accident · No injuriesClosedCessna 140 · Norwood, MAMay 3, 1968 · N72827 · Substantial damage NTSB UNK68X0137Accident · 2 fatalClosedCessna 140 · Tiajuana, MexicoApr 28, 1968 · N76659 · Destroyed NTSB NYC68F0473Accident · No injuriesClosedCessna 140 · Ithaca, NYApr 22, 1968 · N2897N · Substantial damage NTSB SEA68F0322Accident · Serious injuriesClosedCessna 140 · Auburn, WAApr 14, 1968 · N73027 · Destroyed NTSB MIA68D0517Accident · Minor injuriesClosedCessna 140 · Charleston, SCApr 13, 1968 · N2418N · Substantial damage NTSB CHI68D0662Accident · No injuriesClosedCessna 140 · Manton, MIMar 30, 1968 · N2239V · Substantial damage NTSB ANC68F0104Accident · No injuriesClosedCessna 140 · Gulkana, AKMar 15, 1968 · N2215V · Substantial damage NTSB DIA68D0202Accident · No injuriesClosedCessna 140 · Morgantown, WVMar 5, 1968 · N89072 · Substantial damage NTSB SEA68D0271Accident · No injuriesClosedCessna 140 · Beaver Creek, ORMar 3, 1968 · N76167 · Substantial damage NTSB CHI68F0636Accident · No injuriesClosedCessna 140 · Goshen, INMar 1, 1968 · N76043 · Substantial damage NTSB MIA68F0505Accident · No injuriesClosedCessna 140 · Douglasville, GAFeb 25, 1968 · N72583 · Destroyed NTSB OAK68D0317Accident · No injuriesClosedCessna 140 · Oceano, CAFeb 24, 1968 · N76139 · Substantial damage NTSB ANC68F0096Accident · No injuriesClosedCessna 140 · North Pole, AKFeb 10, 1968 · N2680N · Substantial damage NTSB FTW68D0433Accident · No injuriesClosedCessna 140 · Weatherford, TXFeb 8, 1968 · N4180N · Substantial damage NTSB CHI68F0614Accident · Serious injuriesClosedCessna 140 · Terre Haute, INFeb 8, 1968 · N76407 · Substantial damage NTSB LAX68F0298Accident · No injuriesClosedCessna 140 · Hawthorne, CAFeb 5, 1968 · N76584 · Substantial damage NTSB FTW68D0446Accident · No injuriesClosedCessna 140 · Dimmitt, TXFeb 5, 1968 · N71U · Substantial damage NTSB DIA68A0032Accident · 1 fatalClosedCessna 140 · Greensboro, NCFeb 3, 1968 · N72667 · Destroyed NTSB FTW68F0422Accident · No injuriesClosedCessna 140 · Ponca City, OKJan 21, 1968 · N72750 · Substantial damage NTSB OAK68D0270Accident · No injuriesClosedCessna 140 · Half Moon Bay, CAJan 20, 1968 · N89959 · Substantial damage NTSB NYC68D0377Accident · No injuriesClosedCessna 140 · Middletown, NYJan 20, 1968 · N89123 · Substantial damage NTSB NYC68D0356Accident · No injuriesClosedCessna 140 · Milo, MEJan 20, 1968 · N89261 · Substantial damage NTSB DIA68F0152Accident · No injuriesClosedCessna 140 · Fredericksburg, VAJan 20, 1968 · N89535 · Substantial damage NTSB LAX68D0286Accident · No injuriesClosedCessna 140 · Big Bear City, CAJan 12, 1968 · N2322N · Substantial damage NTSB LAX68F0260Accident · Serious injuriesClosedCessna 140 · Redlands, CADec 25, 1967 · N72100 · Destroyed NTSB CHI68D0523Accident · No injuriesClosedCessna 140 · Fitchburg, WIDec 24, 1967 · N1914N · Substantial damage NTSB SEA68D0222Accident · Minor injuriesClosedCessna 140 · Davenport, WADec 1, 1967 · N72232 · Substantial damage NTSB MIA68D0277Accident · No injuriesClosedCessna 140 · White Bluff, TNNov 18, 1967 · N4228N · Substantial damage NTSB UNK68X0108Accident · No injuriesClosedCessna 140 · Egelsbach, GeorgiaNov 16, 1967 · N2211V · Substantial damage NTSB DEN68F0144Accident · No injuriesClosedCessna 140 · Crown Pt, NMNov 11, 1967 · N89436 · Substantial damage NTSB MIA68D0251Accident · No injuriesClosedCessna 140 · Collegedale, TNNov 4, 1967 · N2026V · Substantial damage NTSB FTW68F0327Accident · No injuriesClosedCessna 140 · Dallas, TXNov 4, 1967 · N2242V · Substantial damage NTSB NYC68F0268Accident · Serious injuriesClosedCessna 140 · Wayne, NJOct 30, 1967 · N89161 · Destroyed NTSB CHI68D0411Accident · No injuriesClosedCessna 140 · Norwalk, WIOct 21, 1967 · N89033 · Substantial damage NTSB LAX68F0199Accident · No injuriesClosedCessna 140 · Santa Paula, CAOct 16, 1967 · N81074 · Substantial damage NTSB ANC68D0066Accident · No injuriesClosedCessna 140 · Eureka, AKOct 14, 1967 · N2215V · Substantial damage NTSB LAX68D0154Accident · No injuriesClosedCessna 140 · Hunt.Beach, CAOct 3, 1967 · N89517 · Substantial damage NTSB SEA68D0148Accident · No injuriesClosedCessna 140 · Seattle, WASep 29, 1967 · N76441 · Substantial damage NTSB MKC68D0291Accident · No injuriesClosedCessna 140 · Junction Cty, KSSep 28, 1967 · N3604V · Substantial damage NTSB SEA68F0199Accident · Serious injuriesClosedCessna 140 · Hardin, MTSep 25, 1967 · N76931 · Destroyed NTSB CHI68F0367Accident · No injuriesClosedCessna 140 · Mt.Sterling, ILSep 21, 1967 · N89883 · Substantial damage NTSB NYC68F0279Accident · No injuriesClosedCessna 140 · Bedford, PASep 18, 1967 · N89747 · Substantial damage NTSB MKC68D0334Accident · No injuriesClosedCessna 140 · Fairmont, MNSep 17, 1967 · N73081 · Substantial damage

Back to Cessna 140