Skip to content

NTSB investigations, DC

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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" = 'DC' 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\" = 'DC' 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" = 'DC' 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 DIA69I0063Incident · No injuriesClosedBoeing 727 · Washington, DCMay 9, 1969 · N7279 · No damage NTSB DIA69I0062Incident · No injuriesClosedDouglas DC-9 · Washington, DCMay 8, 1969 · N8924E · No damage NTSB DIA69I0050Incident · Minor injuriesClosedBoeing 727 · Wash Natl Apt, DCMar 23, 1969 · N4618H · No damage NTSB DIA69D0091Accident · No injuriesClosedHughes 269B · Washington, DCOct 15, 1968 · N9474F · Substantial damage NTSB DIA68D0224Accident · No injuriesClosedBeech C35 · Washington, DCMay 2, 1968 · N653D · Substantial damage NTSB DIA68A0035Accident · No injuriesClosedLockheed 188C · Wash.Natl.Apt, DCMar 3, 1968 · N135US · No damage NTSB DIA68A0018Accident · No injuriesClosedSudaviation DA20 · Washington, DCNov 7, 1967 · N809F · Substantial damage NTSB DIA68F0101Accident · No injuriesClosedGlobe GC-1B · Anacostia, DCOct 25, 1967 · N3777K · Substantial damage NTSB DIA68A0006Accident · No injuriesClosedBeech 95-B55 · Washington, DCAug 21, 1967 · N354RJ · Substantial damage NTSB DIA67A0020Accident · No injuriesClosedPiper PA-31 · Washington, DCJun 6, 1967 · N9004Y · Substantial damage NTSB DIA67I0021Incident · No injuriesClosedBoeing B-727 · Washington, DCJun 2, 1967 · N8133N · Minor damage NTSB DIA67I0010Incident · No injuriesClosedBoeing B-727 · Washington, DCFeb 25, 1967 · N468US · Minor damage NTSB NYC67F0415Accident · No injuriesClosedNavion A · Washington, DCDec 6, 1966 · N91662 · Substantial damage NTSB NYC67F0200Accident · No injuriesClosedCessna 310 · Washington, DCJul 18, 1966 · N66E · Substantial damage NTSB NYC66A0124Accident · No injuriesClosedDehavilland DH-104 · Washington, DCMay 4, 1966 · N70L · Substantial damage NTSB NYC66I0101Incident · No injuriesClosedLear Jet 23 · Washington, DCApr 1, 1966 · N4486C · Minor damage NTSB NYC66D0564Accident · No injuriesClosedBeech B-55 · Washington, DCFeb 13, 1966 · N146 · Substantial damage NTSB NYC66F0426Accident · No injuriesClosedBeechcraft H35 · Washington, DCDec 24, 1965 · N194HA · Substantial damage NTSB NYC66F0403Accident · No injuriesClosedCessna 310B · Washington, DCDec 1, 1965 · N5347A · Substantial damage NTSB NYC65A0106Accident · No injuriesClosedNo American 265A · Washington, DCFeb 18, 1965 · N168H · Substantial damage NTSB UNK65X1076Accident · No injuriesClosedBell 47H1 · Washington, DCDec 20, 1964 · N2475B · Substantial damage NTSB UNK65X0905Incident · No injuriesClosedGrumman G159 · Washington, DCDec 2, 1964 · N376 · No damage NTSB UNK64X2013Incident · No injuriesClosedLockheed L-188 · Washington, DCMay 30, 1964 · N537 · No damage NTSB UNK64X1410Accident · No injuriesClosedMeyers 200A · Washington, DCApr 22, 1964 · N34398 · Substantial damage NTSB UNK64X1160Accident · No injuriesClosedCessna 182 · Washington, DCApr 4, 1964 · N3720D · Substantial damage