Skip to content

NTSB investigations, DE

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 IAD70FHD32Accident · No injuriesClosedPiper PA-28 · Newark, DEMay 2, 1970 · N9402W · Substantial damage NTSB IAD70FHD18Accident · No injuriesClosedCessna 310F · New Castle, DEApr 18, 1970 · N5852X · Substantial damage NTSB IAD70FHD06Accident · No injuriesClosedCessna 310L · Middletown, DEFeb 11, 1970 · N3288X · Substantial damage NTSB IAD70FHD03Accident · No injuriesClosedCessna 310L · New Castle, DEJan 22, 1970 · N3354Q · Substantial damage NTSB IAD70D0102Accident · Minor injuriesClosedBeech 23 · Kirkwood, DEOct 27, 1969 · N8731M · Destroyed NTSB IAD70F0080Accident · Minor injuriesClosedPiper PA-28 · New Castle, DESep 14, 1969 · N98297 · Substantial damage NTSB IAD70D0069Accident · Serious injuriesClosedCessna 150 · Smyrna, DESep 5, 1969 · N8238F · Substantial damage NTSB IAD70D0061Accident · No injuriesClosedCessna 172 · Selbyville, DEAug 24, 1969 · N3729L · Substantial damage NTSB DIA70F0038Accident · No injuriesClosedCessna 421 · Cheswold, DEAug 2, 1969 · N2953Q · Substantial damage NTSB IAD70A0007Accident · No injuriesClosedDouglas DC-8 · New Castle, DEJul 20, 1969 · N4909C · Substantial damage NTSB IAD70A0004Accident · 1 fatalClosedBeech 23 · Selbyville, DEJul 19, 1969 · N2329J · Destroyed NTSB DIA70D0013Accident · No injuriesClosedPiper PA-28 · Cheswold, DEJun 20, 1969 · N8224N · Substantial damage NTSB DIA70D0012Accident · No injuriesClosedPiper PA-28R · Laurel, DEMay 18, 1969 · N9342N · Substantial damage NTSB DIA69D0203Accident · No injuriesClosedCessna 150 · Dover, DEApr 18, 1969 · N8946S · Substantial damage NTSB DIA69A0051Accident · No injuriesClosedPiper PA-31 · Wilmington, DEMar 27, 1969 · N9121Y · Substantial damage NTSB DIA69D0148Accident · No injuriesClosedPiper PA-28 · Cheswold, DEFeb 14, 1969 · N6315R · Destroyed NTSB DIA69D0142Accident · No injuriesClosedPiper PA-22 · Middletown, DEJan 26, 1969 · N5157Z · Substantial damage NTSB DIA69D0130Accident · No injuriesClosedPiper PA-28R · Wilmington, DEJan 11, 1969 · N3879T · Substantial damage NTSB DIA69F0050Accident · No injuriesClosedCessna 175 · Laurel, DEAug 3, 1968 · N7537M · Substantial damage NTSB DIA69D0049Accident · No injuriesClosedCessna 150 · Middletown, DEJul 24, 1968 · N3976J · Substantial damage NTSB NYC69I0002Incident · No injuriesClosedBoeing 737 · Kenton, DEJul 2, 1968 · N734N · Minor damage NTSB DIA68D0234Accident · No injuriesClosedCessna 172G · Milford, DEApr 25, 1968 · N1164F · Substantial damage NTSB DIA68D0208Accident · No injuriesClosedCessna 182 · Smyrna, DEApr 14, 1968 · N3046F · Substantial damage NTSB DIA68F0184Accident · No injuriesClosedTermite SL · Middletown, DEMar 25, 1968 · N59322 · Substantial damage NTSB DIA68D0142Accident · No injuriesClosedBeech A23 · Smyrna, DEDec 18, 1967 · N5782V · Substantial damage NTSB DIA68D0139Accident · No injuriesClosedChampion 7ECA · Georgetown, DEDec 14, 1967 · N6342N · Substantial damage NTSB DIA68D0132Accident · No injuriesClosedCessna 150 · Wyoming, DENov 20, 1967 · N8946S · Substantial damage NTSB DIA68D0118Accident · No injuriesClosedBeech 95-C55 · New Castle, DEOct 31, 1967 · N7863L · Substantial damage NTSB DIA68D0111Accident · No injuriesClosedCessna 182F · Greenwood, DEOct 23, 1967 · N3364F · Substantial damage NTSB DIA68D0106Accident · No injuriesClosedCessna 150 · Middletown, DEOct 11, 1967 · N6417S · Substantial damage NTSB DIA68F0108Accident · Serious injuriesClosedCulver LFA · Middletown, DESep 15, 1967 · N29288 · Substantial damage NTSB DIA68A0011Accident · Serious injuriesClosedAero Comdr 1121 · Bear, DESep 11, 1967 · N450JD · Substantial damage NTSB NYC68F0174Accident · No injuriesClosedCessna 150G · Milford, DESep 1, 1967 · N2992J · Substantial damage NTSB DIA68F0075Accident · No injuriesClosedCessna 140 · Wilmington, DEAug 29, 1967 · N89842 · Substantial damage NTSB NYC68D0186Accident · No injuriesClosedCessna 310J · Cheswold, DEAug 23, 1967 · N3031L · Substantial damage NTSB DIA68D0078Accident · No injuriesClosedCessna 206 · New Castle, DEAug 9, 1967 · N5188U · Substantial damage NTSB DIA68D0064Accident · No injuriesClosedBeech SNB-1 · Magnolia, DEJul 26, 1967 · N111Y · Substantial damage NTSB DIA68D0047Accident · No injuriesClosedWren 460 · Middletown, DEJul 16, 1967 · N2547R · Substantial damage NTSB DIA68D0041Accident · No injuriesClosedPiper PA-32 · Cheswold, DEJul 5, 1967 · N4028W · Substantial damage NTSB DIA68D0009Accident · No injuriesClosedCessna 172 · Middletown, DEJun 4, 1967 · N1413F · 2 aircraft · Minor damage NTSB DIA67F0101Accident · No injuriesClosedPiper PA-25 · Cheswold, DEMay 8, 1967 · N4551Y · Destroyed NTSB DIA67D0088Accident · No injuriesClosedCessna 150G · Middletown, DEApr 20, 1967 · N8480J · Substantial damage NTSB DIA67D0059Accident · No injuriesClosedCessna 180 · Middletown, DEMar 10, 1967 · N1797C · Substantial damage NTSB DIA67A0011Accident · 2 fatalClosedBeech C-45H · Middletown, DEFeb 28, 1967 · N830K · Destroyed NTSB DIA67F0061Accident · No injuriesClosedCessna 140 · Wilmington, DEFeb 8, 1967 · N89328 · Substantial damage NTSB NYC67D0334Accident · No injuriesClosedBeech A23-19 · New Castle, DEOct 9, 1966 · N5988S · Substantial damage NTSB NYC67D0182Accident · No injuriesClosedPiper PA-22 · Bridgeville, DEAug 17, 1966 · N5671Z · Substantial damage NTSB NYC67D0199Accident · No injuriesClosedBeech 95-55 · New Castle, DEAug 1, 1966 · N6109V · Substantial damage NTSB NYC67F0130Accident · No injuriesClosedPiper PA-22 · Selbyville, DEJul 16, 1966 · N8759D · Substantial damage NTSB NYC67F0041Accident · No injuriesClosedBeech AT11 · Milford, DEMay 31, 1966 · N4001A · Substantial damage