Skip to content

NTSB investigations, DE

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Defining event

Finding

Phase of flight

Aircraft model

Cases, 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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."eventStateOrRegion" = 'DE' AND c."eventCountry" = 'USA' 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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
  WHERE c.\"eventStateOrRegion\" = 'DE' AND c.\"eventCountry\" = 'USA'
  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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE c."eventStateOrRegion" = 'DE' AND c."eventCountry" = 'USA'
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 NYC66D0539Accident · No injuriesClosedBeech 23 · Wilmington, DEMar 12, 1966 · N8702M · Substantial damage NTSB NYC66D0500Accident · No injuriesClosedPiper PA-28 · Cheswold, DEFeb 20, 1966 · N6331W · Substantial damage NTSB NYC66D0457Accident · No injuriesClosedCessna 175 · Selbyville, DEJan 1, 1966 · N8246T · Substantial damage NTSB NYC66F0299Accident · No injuriesClosedPiper J-3C · Laurel, DEOct 12, 1965 · N6055H · Substantial damage NTSB NYC66D0318Accident · No injuriesClosedCessna 150 · Middletown, DEOct 2, 1965 · N5934T · Substantial damage NTSB NYC66F0265Accident · No injuriesClosedBeechcraft 35 · New Castle, DESep 22, 1965 · N2943V · Substantial damage NTSB NYC66D0241Accident · No injuriesClosedCessna 150 · Laurel, DESep 15, 1965 · N7840Z · Substantial damage NTSB NYC66A0034Accident · No injuriesClosedCurtis C-46 · Dover, DESep 13, 1965 · N5132B · Substantial damage NTSB NYC66D0084Accident · No injuriesClosedPiper PA-22 · Bridgeville, DEJul 5, 1965 · N1420C · Substantial damage NTSB UNK65X1507Accident · No injuriesClosedPiper PA-18 · Rehoboth, DEJun 26, 1965 · N3775Z · Destroyed NTSB NYC66F0030Accident · No injuriesClosedMooney M20 · Milford, DEMay 30, 1965 · N5283B · Substantial damage NTSB UNK65X1494Accident · No injuriesClosedCessna 210 · Laurel, DEMay 28, 1965 · N3922Y · Substantial damage NTSB NYC65F0225Accident · No injuriesClosedBeechcraft B-23 · Smyrna, DEMay 20, 1965 · N8720M · Substantial damage NTSB NYC65D0205Accident · No injuriesClosedPiper J3C · Middletown, DEApr 17, 1965 · N51532 · Substantial damage NTSB NYC65F0223Accident · Minor injuriesClosedBeechcraft D-18S · New Castle, DEApr 2, 1965 · N9910 · Substantial damage NTSB NYC65F0100Accident · Serious injuriesClosedPiper PA-11 · Rehoboth, DEMar 19, 1965 · N4932H · Substantial damage NTSB NYC65D0123Accident · No injuriesClosedAeronca 7AC · Townsend, DEFeb 28, 1965 · N82892 · Substantial damage NTSB NYC65F0122Accident · No injuriesClosedMooney M21 · Wilmington, DEFeb 19, 1965 · N1226X · Substantial damage NTSB NYC65F0124Accident · No injuriesClosedNorth Ameri SNJ-5 · Wilmington, DEJan 31, 1965 · N3673F · Substantial damage NTSB NYC65I0100Incident · No injuriesClosedLockheed L-1049 · Wilmington, DEJan 29, 1965 · N4715G · Minor damage NTSB UNK65X1311Accident · No injuriesClosedPiper PA22 · Cheswold, DEJan 18, 1965 · N5560Z · Substantial damage NTSB UNK65X0131Accident · No injuriesClosedPiper PA18 · Wilmington, DEOct 3, 1964 · N5768D · Substantial damage NTSB UNK64X4211Incident · No injuriesClosedBoeing 707 123B · New Castle, DESep 30, 1964 · N7518 · Minor damage NTSB UNK64X4087Accident · 1 fatalClosedTaylorcraft BC-12D · Middletown, DESep 21, 1964 · N43542 · Destroyed NTSB UNK64X3064Accident · No injuriesClosedCessna 172 · Wilmington, DEJul 27, 1964 · N7790U · Substantial damage NTSB UNK64X2997Accident · No injuriesClosedErcoupe 415E · Middletown, DEJul 23, 1964 · N94866 · Substantial damage NTSB UNK64X2590Accident · No injuriesClosedCessna 172 · Rehobeth, DEJul 1, 1964 · N3949F · Substantial damage NTSB UNK64X1802Accident · No injuriesClosedErcoupe 415CD · Dover, DEMay 17, 1964 · N94682 · Substantial damage NTSB UNK64X1792Accident · 1 fatalClosedAeronca 7FC · Harrington, DEMay 16, 1964 · N9066B · Destroyed NTSB UNK64X1778Accident · No injuriesClosedBoeing A75 · Middletown, DEMay 16, 1964 · N60700 · Minor damage NTSB UNK64X1180Accident · No injuriesClosedCessna 195 · Wyoming, DEApr 5, 1964 · N4357N · Substantial damage NTSB UNK64X1144Accident · No injuriesClosedCessna 172 · Ilmington, DEApr 3, 1964 · N7046A · Substantial damage NTSB UNK64X1027Accident · No injuriesClosedPiper PA18 · Frankford, DEMar 24, 1964 · N170T · Substantial damage NTSB NYC62A0067Accident · No injuriesClosedArmstrong AW650 · Wilmington, DEJul 2, 1962 · N6501R · Substantial damage