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 DCA07WA028Incident · No injuriesForeign investigationBoeing 737-400 · Alghero Fertili, ItalyFeb 17, 2007 · EI-CZG · Minor damageNTSB DEN07WA062Accident · 1 fatalForeign investigationPiper PA-34-200T · Natal, BrazilFeb 16, 2007 · D-GOMM · DestroyedNTSB NYC07RA064Accident · Serious injuriesForeign investigationBombardier CL-600-2B19 · Moscow, RussiaFeb 13, 2007 · N168CK · DestroyedNTSB DEN07WA060Accident · 1 fatalForeign investigationPiper PA-31T · Rieschweiler, GermanyFeb 12, 2007 · N160TR · DestroyedNTSB ENG07WA025Incident · No injuriesForeign investigationBoeing 747 · Seoul, South KoreaFeb 10, 2007 · HL7488 · No damageNTSB ENG07WA019Incident · No injuriesForeign investigationAirbus A300 · Shanghai, ChinaFeb 10, 2007 · TC-ABK · No damageNTSB DEN07WA061Accident · 3 fatalForeign investigationPiper PA-34-200T · Gresse-en-Verco, FranceFeb 10, 2007 · N2195B · DestroyedNTSB LAX07WA082Accident · Serious injuriesForeign investigationCirrus SR22 · Sydney, AustraliaFeb 5, 2007 · VH-HYY · Substantial damageNTSB CHI07WA065Accident · 2 fatalForeign investigationPiper PA-28-140 · Blackpool, United KingdomFeb 3, 2007 · G-BBBK · Substantial damageNTSB LAX07WA083Accident · No injuriesForeign investigationBell 407 · Warialda, AustraliaFeb 2, 2007 · VH-HRT · Substantial damageNTSB DCA07WA024Accident · 1 fatalForeign investigationCirrus Design SR20 · Greenland, GreenlandFeb 2, 2007 · N901SR · DestroyedNTSB CHI07WA066Accident · Serious injuriesForeign investigationRobinson R44 II · Cambridge, CanadaFeb 2, 2007 · C-FGTN · Substantial damageNTSB LAX07WA084Accident · 3 fatalForeign investigationCessna 172RG · Nadi, FijiFeb 1, 2007 · DQ-SKY · DestroyedNTSB DCA08WA049Incident · No injuriesForeign investigationAirbus Industrie A310 · Santa Maria, PortugalJan 28, 2007 · CS-TKM · No damageNTSB DFW07WA062Accident · Serious injuriesForeign investigationHiller UH-12B · Panama City, PanamaJan 25, 2007 · N727JR · Substantial damageNTSB DCA07WA023Accident · No injuriesForeign investigationRaytheon B-1900 · Samedan, SwitzerlandJan 25, 2007 · F-HALS · Minor damageNTSB DEN07WA064Incident · No injuriesForeign investigationCessna 550 Bravo · Samedan, SwitzerlandJan 24, 2007 · LZ-ABV · Minor damageNTSB ENG07WA024Incident · No injuriesForeign investigationAirbus Industrie A300-600 · Kota Kinabalu, MalaysiaJan 23, 2007 · HL7297 · No damageNTSB ENG07RA012Incident · No injuriesForeign investigationDassault FALCON900 · Gatwick, United KingdomJan 20, 2007 · G-HMEV · Minor damageNTSB DEN07WA050Accident · No injuriesForeign investigationPiper PA-34-200 · Saint Francois, GuadeloupeJan 13, 2007 · N341TJ · Substantial damageNTSB MIA07RA034Accident · 2 fatalForeign investigationGates Learjet 24F · Guadalajara, MexicoJan 10, 2007 · N444TW · DestroyedNTSB ANC07WA012Accident · 1 fatalForeign investigationBeech A-100 · Sandy Bay, CanadaJan 8, 2007 · C-GFFN · Substantial damageNTSB WAS07WA007Accident · 1 fatalForeign investigationPiper PA-31-350 · Selous, TanzaniaJan 5, 2007 · 5H-MUX · DestroyedNTSB DCA07RA019Accident · 102 fatalForeign investigationBoeing 737-400 · Makassar, IndonesiaJan 1, 2007 · PK-KKW