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.

NTSB MIA07WA113Accident · No injuriesForeign investigationBeech 1900D · Marlborough, New ZealandJun 18, 2007 · ZK-EAK · Substantial damageNTSB DCA07WA049Accident · 6 fatalForeign investigationCessna U206F · Chelinda, MalawiJun 16, 2007 · 7Q-YNS · DestroyedNTSB DFW07WA137Accident · 2 fatalForeign investigationCessna 182 · San Luis Gonzag, MexicoJun 15, 2007 · N5603B · DestroyedNTSB DFW07WA135Accident · 2 fatalForeign investigationBell 212 · Guipuzcoa, SpainJun 13, 2007 · EC-FBM · DestroyedNTSB MIA07WA105Accident · 2 fatalForeign investigationBell 206L-3 · Simiti, Bolivar, ColombiaJun 5, 2007 · HK4400 · Substantial damageNTSB NYC07WA129Accident · 1 fatalForeign investigationRobinson R-44 · Kashira, RussiaJun 3, 2007 · RA-04140 · Substantial damageNTSB DFW07WA133Accident · 1 fatalForeign investigationCessna 172P · Meranges, SpainJun 3, 2007 · EC-HOT · DestroyedNTSB NYC07WA142Accident · 4 fatalForeign investigationRobinson R-44 · Teramo, ItalyJun 2, 2007 · I-CSDI · Substantial damageNTSB ANC07WA041Accident · 1 fatalForeign investigationBell 412SP · Nakatsugawa, JapanJun 2, 2007 · JA-9991 · DestroyedNTSB DEN07WA106Accident · No injuriesForeign investigationGulfstream Aerospace G-V · Zurich, SwitzerlandJun 1, 2007 · HB-IMJ · Minor damageNTSB LAX07WA190Incident · No injuriesForeign investigationBeech 200 · Victoria, AustraliaMay 31, 2007 · VH-XCB · No damageNTSB MIA07WA145Accident · No injuriesForeign investigationDouglas DC-3 · Acaricuara, ColombiaMay 25, 2007 · HK3199 · Substantial damageNTSB ENG07WA041Incident · No injuriesForeign investigationBeech B200 · Broome, Australia, AustraliaMay 24, 2007 · VH-IWO · No damageNTSB DEN07WA093Accident · 1 fatalForeign investigationGrumman American AG-5B · Fulda-Jossa, GermanyMay 23, 2007 · D-EPTP · Substantial damageNTSB DFW07WA113Accident · 1 fatalForeign investigationCessna A188B · San Francisco, HondurasMay 13, 2007 · HR-ATW · DestroyedNTSB DFW07WA110Accident · 1 fatalForeign investigationBell 47G · Ciudad Victoria, MexicoMay 12, 2007 · N25802 · Substantial damageNTSB DCA07WA041Incident · No injuriesForeign investigationBoeing 777-200ER · Tel Aviv, IsraelMay 12, 2007 · N863DA · Minor damageNTSB CHI07WA141Incident · No injuriesForeign investigationDassault-Breguet Mystere Falcon 20-F5 · London, United KingdomMay 9, 2007 · N757CX · No damageNTSB ENG08WA004Incident · No injuriesForeign investigationAgusta A.109 Mk.II · Cork, IrelandMay 7, 2007 · EI-ECA · No damageNTSB DCA07RA040Accident · 114 fatalForeign investigationBoeing B737-800 · Douala, CameroonMay 5, 2007 · 5Y-KYANTSB CHI07WA133Accident · No injuriesForeign investigationEurocopter AS355F2 · Peterborough, United KingdomMay 1, 2007 · G-BYPA · Substantial damageNTSB DCA07WA044Incident · No injuriesForeign investigationBoeing 737-300 · BrazilApr 29, 2007 · PR-GLC · No damageNTSB DFW07WA100Accident · 1 fatalForeign investigationCessna 210 · Palma Real, HondurasApr 28, 2007 · TG-MAP · DestroyedNTSB NYC07WA152Accident · No injuriesForeign investigationErickson S-64F · La Spezia, ItalyApr 26, 2007 · I-SEAD · DestroyedNTSB MIA07WA159Accident · 3 fatalForeign investigationBritten-Norman BN2A Islander · Kopinang, GuyanaApr 25, 2007 · 8R-GET · DestroyedNTSB DFW07WA094Accident · 2 fatalForeign investigationBell 206 · Changuinola, PanamaApr 21, 2007 · HP1602HFNNTSB DCA07WA042Incident · No injuriesForeign investigationSikorsky 76-C+ · North Sea, United KingdomApr 21, 2007 · LN-ONZ · No damageNTSB ENG07WA027Incident · No injuriesForeign investigationBoeing 747-300 · Dammam, Saudi ArabiaApr 19, 2007 · TFATJ · Minor damageNTSB MIA07WA082Incident · No injuriesForeign investigationBeech 1900D · Marsh Harbour, BahamasApr 18, 2007 · N46AR · No damageNTSB DEN07WA095Accident · No injuriesForeign investigationSikorsky S61N · Gamle Qutdligss, GreenlandApr 18, 2007 · OY-HGZ · Substantial damageNTSB 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.Apr 10, 2007 · N444JH · DestroyedNTSB CHI07WA099Accident · 3 fatalForeign investigationPiper PA-28R-201T · Oban, Scotland, United KingdomApr 9, 2007 · G-JMTT · Substantial damageNTSB ENG07RA021Incident · No injuriesForeign investigationBoeing 747-400 Cargo · Chengdu, ChinaApr 3, 2007 · HL7499NTSB ENG07WA031Accident · No injuriesForeign investigationIsrael Aircraft Industries 1124 · Darwin, AustraliaApr 2, 2007 · VH-AJP · Substantial damageNTSB DEN07WA081Accident · 2 fatalForeign investigationPiper PA-34-200T · Klagenfurt, AustriaApr 1, 2007 · DGMBE · DestroyedNTSB ENG07WA022Incident · No injuriesForeign investigationPiper PA28-181 · Amman, JordanMar 28, 2007 · JY-RJC · Minor damageNTSB LAX07WA235Accident · No injuriesForeign investigationEmbraer E-170 · Riyadh, Saudi ArabiaMar 27, 2007 · HZ-AEN · No damageNTSB DFW07WA095Accident · No injuriesForeign investigationCessna 208B · Quepos, Costa RicaMar 22, 2007 · TI-BBG · Minor damageNTSB ENG07WA020Incident · No injuriesForeign investigationBoeing 747 · Shanghai, ChinaMar 21, 2007 · B2450 · No damageNTSB ENG07WA016Incident · No injuriesForeign investigationLockheed L188C · Stansted, United KingdomMar 19, 2007 · G-FIZU · No damageNTSB DEN07WA075Accident · 1 fatalForeign investigationBeech 24R · Rendsburg-Schac, GermanyMar 19, 2007 · D-EDER · DestroyedNTSB CEN10WA040Accident · No injuriesForeign investigationColumbia LC42-550FG · Casarrubios del Monte, SpainMar 10, 2007 · N1271B · Substantial damageNTSB WAS07WA009Accident · 2 fatalForeign investigationPiper PA-34-200T · Lilongwe, MalawiMar 9, 2007 · ZS-MSN · DestroyedNTSB DEN07WA067Accident · Minor injuriesForeign investigationEurocopter EC120B · Vreden, GermanyMar 7, 2007 · N263CP · 2 aircraft · Minor damageNTSB DCA07RA030Accident · 23 fatalForeign investigationBoeing B737-400 · Yogyakarta, IndonesiaMar 7, 2007 · PK-GZCNTSB DCA07WA029Incident · No injuriesForeign investigationBoeing 767-300 · London, United KingdomMar 3, 2007 · V8-RBH · Minor damageNTSB ENG07RA014Accident · No injuriesForeign investigationBoeing 777-200B · London, United KingdomFeb 26, 2007 · N786UA · Substantial damageNTSB LAX07WA095Accident · 2 fatalForeign investigationRV-4 · Officer South, AustraliaFeb 23, 2007 · VH-ZGH · Substantial damageNTSB DCA07WA027Accident · No injuriesForeign investigationBoeing · Surabaya, IndonesiaFeb 21, 2007 · PKKKV · DestroyedNTSB ENG07WA017Accident · No injuriesForeign investigationBell 212 · Sao Paulo,, BrazilFeb 20, 2007 · No damage