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 OAK66F0021Accident · Minor injuriesClosedCessna 140 · Dos Palos, CAJun 27, 1965 · N2244N · Substantial damage NTSB NYC66D0059Accident · Minor injuriesClosedCessna 140 · Odenton, MDJun 27, 1965 · N72455 · Destroyed NTSB DEN66D0043Accident · No injuriesClosedCessna 140 · Hereford, AZJun 27, 1965 · N1634V · Substantial damage NTSB LAX66F0003Accident · Serious injuriesClosedCessna 140 · Lathrop Wells, NVJun 21, 1965 · N72467 · Substantial damage NTSB MIA66D0043Accident · Minor injuriesClosedCessna 140 · Chattanooga, TNJun 20, 1965 · N72386 · Substantial damage NTSB DEN66D0025Accident · No injuriesClosedCessna 140 · Clovis, NMJun 18, 1965 · N89428 · Substantial damage NTSB CHI66D0069Accident · No injuriesClosedCessna 140 · Clay City, INJun 16, 1965 · N2446N · Substantial damage NTSB LAX66F0040Accident · Minor injuriesClosedCessna 140 · Torrance, CAJun 14, 1965 · N89413 · Substantial damage NTSB CHI66F0061Accident · No injuriesClosedCessna 140 · East Moline, ILJun 12, 1965 · N1891V · Substantial damage NTSB MKC66F0067Accident · No injuriesClosedCessna 140 · Columbia, SDJun 10, 1965 · N2341N · Substantial damage NTSB CHI66F0206Accident · No injuriesClosedCessna 140 · Joliet, ILJun 9, 1965 · N2353V · Substantial damage NTSB NYC66F0102Accident · No injuriesClosedCessna 140 · Cambridge, NYJun 6, 1965 · N76065 · 2 aircraft · Substantial damage NTSB CHI65F0205Accident · No injuriesClosedCessna 140 · Chesapeake, OHJun 6, 1965 · N1693V · Substantial damage NTSB MIA65F0114Accident · No injuriesClosedCessna 140 · Bessemer, ALJun 4, 1965 · N3563V · Substantial damage NTSB MIA66D0054Accident · No injuriesClosedCessna 140 · Franklin, NCMay 31, 1965 · N90170 · Substantial damage NTSB MKC66D0017Accident · No injuriesClosedCessna 140 · Lamberton, MNMay 30, 1965 · N89297 · Substantial damage NTSB CHI66F0027Accident · No injuriesClosedCessna 140 · Ramsey, INMay 29, 1965 · N76735 · Substantial damage NTSB MKC66D0099Accident · Minor injuriesClosedCessna 140 · Ely, MNMay 28, 1965 · N72683 · Substantial damage NTSB NYC66F0019Accident · No injuriesClosedCessna 140 · Zelienople, PAMay 26, 1965 · N508D · Substantial damage NTSB OAK66F0012Accident · Minor injuriesClosedCessna 140 · Montague, CAMay 25, 1965 · N77S · Substantial damage NTSB CHI65F0186Accident · No injuriesClosedCessna 140 · Cincinnati, OHMay 21, 1965 · N89026 · Substantial damage NTSB MKC66F0002Accident · No injuriesClosedCessna 140 · Columbia, MOMay 17, 1965 · N2344V · Substantial damage NTSB NYC65D0204Accident · No injuriesClosedCessna 120 · Marlton, NJMay 6, 1965 · N3542V · Substantial damage NTSB MIA65D0074Accident · No injuriesClosedCessna 140 · Knoxville, TNMay 5, 1965 · N2388N · Substantial damage NTSB DEN65D0073Accident · No injuriesClosedCessna 140 · Aneth, UTMay 3, 1965 · N76906 · Substantial damage NTSB CHI65F0177Accident · No injuriesClosedCessna 140 · Pontiac, MIMay 1, 1965 · N76943 · Substantial damage NTSB LAX65D0073Accident · No injuriesClosedCessna 140 · Ely, NVApr 26, 1965 · N76367 · Substantial damage NTSB NYC65F0183Accident · No injuriesClosedCessna 140 · Rochester, NHApr 21, 1965 · N2440N · Substantial damage NTSB MKC65F0122Accident · No injuriesClosedCessna 140 · Maryville, MOApr 20, 1965 · N89826 · Substantial damage NTSB FTW65F0023Accident · Minor injuriesClosedCessna 140 · Tulsa, OKApr 14, 1965 · N1794V · Substantial damage NTSB MKC66D0075Accident · No injuriesClosedCessna 140 · Kirksville, MOApr 13, 1965 · N2296V · Substantial damage NTSB CHI65D0061Accident · No injuriesClosedCessna 140 · Newark, OHApr 6, 1965 · N72782 · Substantial damage NTSB MKC65F0108Accident · No injuriesClosedCessna 140 · Minneapolis, MNMar 30, 1965 · N72108 · Substantial damage NTSB CHI65F0115Accident · No injuriesClosedCessna 140 · Hastings, MIMar 28, 1965 · N89480 · Substantial damage NTSB SEA65F0025Accident · No injuriesClosedCessna 140 · Lebanon, ORMar 27, 1965 · N2593N · Substantial damage NTSB SEA65F0057Accident · No injuriesClosedCessna 140 · Great Falls, MTMar 21, 1965 · N2585N · Substantial damage NTSB NYC65F0068Accident · No injuriesClosedCessna 140 · Prospectville, PAMar 21, 1965 · N89286 · Substantial damage NTSB MKC65F0066Accident · No injuriesClosedCessna 140 · Rapid City, SDMar 20, 1965 · N2335V · Substantial damage NTSB FTW65F0002Accident · No injuriesClosedCessna 140 · Fort Hood, TXMar 15, 1965 · N72949 · Substantial damage NTSB NYC65D0127Accident · No injuriesClosedCessna 140 · Pitman, NJMar 14, 1965 · N76391 · Substantial damage NTSB SEA65F0020Accident · No injuriesClosedCessna 140 · Pullman, WAMar 9, 1965 · N72232 · Substantial damage NTSB MIA65F0006Accident · No injuriesClosedCessna 140 · Batesville, MSMar 8, 1965 · N72717 · Substantial damage NTSB UNK65X1468Accident · No injuriesClosedCessna 140 · Jamison, ALMar 7, 1965 · N72207 · Substantial damage NTSB NYC65F0101Accident · Serious injuriesClosedCessna 140 · Troutville, VAMar 6, 1965 · N76467 · Substantial damage NTSB MKC65D0046Accident · No injuriesClosedCessna 140 · Davenport, IAMar 6, 1965 · N2733N · Substantial damage NTSB MKC65F0090Accident · No injuriesClosedCessna 140 · Aitkin, MNFeb 28, 1965 · N89164 · Destroyed NTSB UNK65X1461Accident · No injuriesClosedCessna 140 · Jacksonville, FLFeb 27, 1965 · N3125N · Destroyed NTSB OAK65F0022Accident · No injuriesClosedCessna 140 · Salinas, CAFeb 19, 1965 · N76547 · Substantial damage NTSB CHI65D0048Accident · No injuriesClosedCessna 140 · Sugar Grove, ILFeb 14, 1965 · N76095 · Substantial damage NTSB LAX66D0010Accident · Serious injuriesClosedCessna 140 · Upland, CAFeb 12, 1965 · N2235N · Substantial damage

Back to Cessna 140