NTSB investigations, 2007, Outside the U.S.
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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.
Cases, newest first
Query with SQL
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 year(c.\"eventDate\") = 2007
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 year(c."eventDate") = 2007 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 DCA07WA028Incident · No injuriesForeign investigationBoeing 737-400 · Alghero Fertili, ItalyNTSB DEN07WA062Accident · 1 fatalForeign investigationPiper PA-34-200T · Natal, BrazilNTSB NYC07RA064Accident · Serious injuriesForeign investigationBombardier CL-600-2B19 · Moscow, RussiaNTSB DEN07WA060Accident · 1 fatalForeign investigationPiper PA-31T · Rieschweiler, GermanyNTSB ENG07WA025Incident · No injuriesForeign investigationBoeing 747 · Seoul, South KoreaNTSB ENG07WA019Incident · No injuriesForeign investigationAirbus A300 · Shanghai, ChinaNTSB DEN07WA061Accident · 3 fatalForeign investigationPiper PA-34-200T · Gresse-en-Verco, FranceNTSB LAX07WA082Accident · Serious injuriesForeign investigationCirrus SR22 · Sydney, AustraliaNTSB CHI07WA065Accident · 2 fatalForeign investigationPiper PA-28-140 · Blackpool, United KingdomNTSB LAX07WA083Accident · No injuriesForeign investigationBell 407 · Warialda, AustraliaNTSB DCA07WA024Accident · 1 fatalForeign investigationCirrus Design SR20 · Greenland, GreenlandNTSB CHI07WA066Accident · Serious injuriesForeign investigationRobinson R44 II · Cambridge, CanadaNTSB LAX07WA084Accident · 3 fatalForeign investigationCessna 172RG · Nadi, FijiNTSB DCA08WA049Incident · No injuriesForeign investigationAirbus Industrie A310 · Santa Maria, PortugalNTSB DFW07WA062Accident · Serious injuriesForeign investigationHiller UH-12B · Panama City, PanamaNTSB DCA07WA023Accident · No injuriesForeign investigationRaytheon B-1900 · Samedan, SwitzerlandNTSB DEN07WA064Incident · No injuriesForeign investigationCessna 550 Bravo · Samedan, SwitzerlandNTSB ENG07WA024Incident · No injuriesForeign investigationAirbus Industrie A300-600 · Kota Kinabalu, MalaysiaNTSB ENG07RA012Incident · No injuriesForeign investigationDassault FALCON900 · Gatwick, United KingdomNTSB DEN07WA050Accident · No injuriesForeign investigationPiper PA-34-200 · Saint Francois, GuadeloupeNTSB MIA07RA034Accident · 2 fatalForeign investigationGates Learjet 24F · Guadalajara, MexicoNTSB ANC07WA012Accident · 1 fatalForeign investigationBeech A-100 · Sandy Bay, CanadaNTSB WAS07WA007Accident · 1 fatalForeign investigationPiper PA-31-350 · Selous, TanzaniaNTSB DCA07RA019Accident · 102 fatalForeign investigationBoeing 737-400 · Makassar, Indonesia