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 MIA07WA113Accident · No injuriesForeign investigationBeech 1900D · Marlborough, New ZealandNTSB DCA07WA049Accident · 6 fatalForeign investigationCessna U206F · Chelinda, MalawiNTSB DFW07WA137Accident · 2 fatalForeign investigationCessna 182 · San Luis Gonzag, MexicoNTSB DFW07WA135Accident · 2 fatalForeign investigationBell 212 · Guipuzcoa, SpainNTSB MIA07WA105Accident · 2 fatalForeign investigationBell 206L-3 · Simiti, Bolivar, ColombiaNTSB NYC07WA129Accident · 1 fatalForeign investigationRobinson R-44 · Kashira, RussiaNTSB DFW07WA133Accident · 1 fatalForeign investigationCessna 172P · Meranges, SpainNTSB NYC07WA142Accident · 4 fatalForeign investigationRobinson R-44 · Teramo, ItalyNTSB ANC07WA041Accident · 1 fatalForeign investigationBell 412SP · Nakatsugawa, JapanNTSB DEN07WA106Accident · No injuriesForeign investigationGulfstream Aerospace G-V · Zurich, SwitzerlandNTSB LAX07WA190Incident · No injuriesForeign investigationBeech 200 · Victoria, AustraliaNTSB MIA07WA145Accident · No injuriesForeign investigationDouglas DC-3 · Acaricuara, ColombiaNTSB ENG07WA041Incident · No injuriesForeign investigationBeech B200 · Broome, Australia, AustraliaNTSB DEN07WA093Accident · 1 fatalForeign investigationGrumman American AG-5B · Fulda-Jossa, GermanyNTSB DFW07WA113Accident · 1 fatalForeign investigationCessna A188B · San Francisco, HondurasNTSB DFW07WA110Accident · 1 fatalForeign investigationBell 47G · Ciudad Victoria, MexicoNTSB DCA07WA041Incident · No injuriesForeign investigationBoeing 777-200ER · Tel Aviv, IsraelNTSB CHI07WA141Incident · No injuriesForeign investigationDassault-Breguet Mystere Falcon 20-F5 · London, United KingdomNTSB ENG08WA004Incident · No injuriesForeign investigationAgusta A.109 Mk.II · Cork, IrelandNTSB DCA07RA040Accident · 114 fatalForeign investigationBoeing B737-800 · Douala, CameroonNTSB CHI07WA133Accident · No injuriesForeign investigationEurocopter AS355F2 · Peterborough, United KingdomNTSB DCA07WA044Incident · No injuriesForeign investigationBoeing 737-300 · BrazilNTSB DFW07WA100Accident · 1 fatalForeign investigationCessna 210 · Palma Real, HondurasNTSB NYC07WA152Accident · No injuriesForeign investigationErickson S-64F · La Spezia, ItalyNTSB MIA07WA159Accident · 3 fatalForeign investigationBritten-Norman BN2A Islander · Kopinang, GuyanaNTSB DFW07WA094Accident · 2 fatalForeign investigationBell 206 · Changuinola, PanamaNTSB DCA07WA042Incident · No injuriesForeign investigationSikorsky 76-C+ · North Sea, United KingdomNTSB ENG07WA027Incident · No injuriesForeign investigationBoeing 747-300 · Dammam, Saudi ArabiaNTSB MIA07WA082Incident · No injuriesForeign investigationBeech 1900D · Marsh Harbour, BahamasNTSB DEN07WA095Accident · No injuriesForeign investigationSikorsky S61N · Gamle Qutdligss, GreenlandNTSB MIA07LA073Accident · 2 fatalLimited investigationFinal reportPiper PA-46-310P · Bird Cay, BahamasThe pilot's poor in-flight weather evaluation, which resulted in flight into a level 6 thunderstorm.NTSB CHI07WA099Accident · 3 fatalForeign investigationPiper PA-28R-201T · Oban, Scotland, United KingdomNTSB ENG07RA021Incident · No injuriesForeign investigationBoeing 747-400 Cargo · Chengdu, ChinaNTSB ENG07WA031Accident · No injuriesForeign investigationIsrael Aircraft Industries 1124 · Darwin, AustraliaNTSB DEN07WA081Accident · 2 fatalForeign investigationPiper PA-34-200T · Klagenfurt, AustriaNTSB ENG07WA022Incident · No injuriesForeign investigationPiper PA28-181 · Amman, JordanNTSB LAX07WA235Accident · No injuriesForeign investigationEmbraer E-170 · Riyadh, Saudi ArabiaNTSB DFW07WA095Accident · No injuriesForeign investigationCessna 208B · Quepos, Costa RicaNTSB ENG07WA020Incident · No injuriesForeign investigationBoeing 747 · Shanghai, ChinaNTSB ENG07WA016Incident · No injuriesForeign investigationLockheed L188C · Stansted, United KingdomNTSB DEN07WA075Accident · 1 fatalForeign investigationBeech 24R · Rendsburg-Schac, GermanyNTSB CEN10WA040Accident · No injuriesForeign investigationColumbia LC42-550FG · Casarrubios del Monte, SpainNTSB WAS07WA009Accident · 2 fatalForeign investigationPiper PA-34-200T · Lilongwe, MalawiNTSB DEN07WA067Accident · Minor injuriesForeign investigationEurocopter EC120B · Vreden, GermanyNTSB DCA07RA030Accident · 23 fatalForeign investigationBoeing B737-400 · Yogyakarta, IndonesiaNTSB DCA07WA029Incident · No injuriesForeign investigationBoeing 767-300 · London, United KingdomNTSB ENG07RA014Accident · No injuriesForeign investigationBoeing 777-200B · London, United KingdomNTSB LAX07WA095Accident · 2 fatalForeign investigationRV-4 · Officer South, AustraliaNTSB DCA07WA027Accident · No injuriesForeign investigationBoeing · Surabaya, IndonesiaNTSB ENG07WA017Accident · No injuriesForeign investigationBell 212 · Sao Paulo,, Brazil