Skip to content

NTSB investigations, 2003, Outside the U.S.

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 year(c."eventDate") = 2003 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 year(c.\"eventDate\") = 2003
    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") = 2003
  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 FTW03WA210Accident · 3 fatalForeign investigationCessna R172K · Juan de Morros, VenezuelaAug 29, 2003 · YV-1739P · Destroyed NTSB MIA03WA172Accident · 1 fatalForeign investigationPiper PA-38-112 · Penalolen, ChileAug 27, 2003 · CC-CRY · Destroyed NTSB MIA03WA178Accident · Serious injuriesForeign investigationCessna 150 · Punta Cana, Dominican RepublicAug 21, 2003 · HI-648SP · Substantial damage NTSB FTW03WA221Accident · Serious injuriesForeign investigationCessna 152 · Punta Cana, Dominican RepublicAug 21, 2003 · HI648SP · Substantial damage NTSB ENG04WA004Accident · No injuriesForeign investigationBell 204B · Bonapart Lake, CanadaAug 17, 2003 · C-GEAP · Destroyed NTSB FTW03WA218Accident · 1 fatalForeign investigationPiper PA-28-140 · Chilpancingo, MexicoAug 16, 2003 · N1647J · Substantial damage NTSB MIA03WA164Accident · No injuriesForeign investigationGates Learjet 35A · Cancun, MexicoAug 15, 2003 · N403FW · Substantial damage NTSB ATL04WA043Accident · Minor injuriesForeign investigationCirrus Design SR-20 · Teuge, NetherlandsAug 15, 2003 · N209CD · Substantial damage NTSB LAX03WA278Accident · No injuriesForeign investigationPiper PA-31-350 · Albury, AustraliaAug 12, 2003 · VH-UBC · Substantial damage NTSB LAX03WA281Accident · 1 fatalForeign investigationCessna 404 · Jandakot, AustraliaAug 11, 2003 · VH-ANV · Destroyed NTSB FTW03WA193Accident · 2 fatalForeign investigationCessna 185F · Prto. Echeverry, ColombiaAug 9, 2003 · HK-1661P · Destroyed NTSB ENG04RA001Incident · No injuriesForeign investigationAirbus Industrie A330 · Brussels, BelgiumimportAug 9, 2003 · OO-SFO · No damage NTSB MIA03WA161Accident · Serious injuriesForeign investigationCessna 208B · Tocomita, VenezuelaAug 8, 2003 · YV-1069C · Substantial damage NTSB MIA03WA156Accident · 1 fatalForeign investigationRobinson R-22 · Santo Domingo, Dominican RepublicAug 3, 2003 · HI-682SP · Destroyed NTSB NYC03WA174Accident · 1 fatalForeign investigationCessna 182T · Buckinghamshire, United KingdomAug 1, 2003 · N666JH · Substantial damage NTSB MIA03WA159Accident · 1 fatalForeign investigationCessna 551 · Sorocaba, BrazilJul 23, 2003 · PT-LME · Substantial damage NTSB SEA03WA159Accident · No injuriesForeign investigationHughes 369D · Powell River BC, CanadaJul 21, 2003 · C-FOHX · Substantial damage NTSB WAS03WA017Accident · 3 fatalForeign investigationHughes 369HS · Sevenoaks, Kent, United KingdomJul 19, 2003 · G-CSPJ · Destroyed NTSB WAS03RA016Accident · 14 fatalForeign investigationSwearingen SA-226TC · Mount Kenya,, KenyaJul 19, 2003 · ZS-OYI NTSB MIA03WA147Accident · 1 fatalForeign investigationPiper PA-23-235 · Freeport, BahamasJul 18, 2003 · N4928P · Destroyed NTSB DCA03WA055Incident · No injuriesForeign investigationMcDonnell Douglas MD-83 · Londonderry, United KingdomJul 17, 2003 · SE-RDL · Minor damage NTSB DCA03WA045Accident · 2 fatalForeign investigationLockheed L-188A · Cranbrook, CanadaJul 16, 2003 · C-GFQA · Destroyed NTSB WAS03WA014Accident · 4 fatalForeign investigationCessna 182 RG · Pianello/Carena, SwitzerlandJul 13, 2003 · N6412T · Destroyed NTSB MIA03FA141Accident · 2 fatalClass 1 · FieldFinal reportCessna 402C · Treasure Cay, Bahamasthe in-flight failure of the right engine and the pilot’s failure to adequately manage the airplane’s performance after the engine failed. The right engine failure resulted from inadequate maintenance that was performed by Air Sunshine’s maintenance personnel…Jul 13, 2003 · N314AB · Substantial damage NTSB ENG04WA019Accident · 3 fatalForeign investigationBeech A-36 · Miyazaki Airpor, JapanJul 11, 2003 · JA4166 · Destroyed NTSB MIA03WA142Accident · 3 fatalForeign investigationBeech S-35 · San Vito Java, Costa RicaJul 10, 2003 · N80695 · Destroyed NTSB WAS03RA019Accident · 115 fatalForeign investigationBoeing 737-200 · Port Sudan, SudanJul 8, 2003 · ST-AFK · Destroyed NTSB FTW03WA185Accident · No injuriesForeign investigationCessna 208B · Turpo, PeruJul 8, 2003 · OB-1741 · Substantial damage NTSB CHI03WA198Accident · 1 fatalForeign investigationBeech BE-58TC · Toronto, CanadaJul 7, 2003 · N6058T · Substantial damage NTSB DCA03WA043Accident · No injuriesForeign investigationBoeing DC-10 · Parana, BrazilJul 6, 2003 · OB-1749 · Substantial damage NTSB MIA03WA137Accident · 2 fatalForeign investigationPiper PA-34-220T · Estancia, ParaguayJul 5, 2003 · PT-VOO · Destroyed NTSB MIA03WA136Accident · 1 fatalForeign investigationCessna 182 · Uriman, VenezuelaJul 5, 2003 · YV-1015P · Destroyed NTSB FTW03WA183Accident · Minor injuriesForeign investigationCessna 208B · Bahia Ballena, Costa RicaJul 3, 2003 · HP 1403APP · Substantial damage NTSB WAS03WA018Accident · Minor injuriesForeign investigationHughes 369D · Chung Cheong, South KoreaJun 30, 2003 · HL-9140 · Substantial damage NTSB FTW03WA194Accident · Minor injuriesForeign investigationCessna TU-206F · Palencia, GuatemalaJun 23, 2003 · TG-PAR · Substantial damage NTSB LAX03WA223Accident · 4 fatalForeign investigationCessna 172 · Cambelltown, AustraliaJun 22, 2003 · VHTUR · Destroyed NTSB DCA03WA041Accident · 1 fatalForeign investigationCanadair CRJ-100 · Brest, FranceJun 22, 2003 · F-GRJS · Destroyed NTSB LAX03WA222Accident · 2 fatalForeign investigationRobinson R-22M · Camden, AustraliaJun 20, 2003 · VHOHA · Destroyed NTSB SEA03WA114Accident · 2 fatalForeign investigationPiper PA-12 · Nimpo Lake, BC, CanadaJun 19, 2003 · N3351M · Destroyed NTSB LAX03WA205Accident · No injuriesForeign investigationCessna T210L · Anahim Lake, CanadaJun 18, 2003 · N210VC · Substantial damage NTSB MIA03WA126Accident · No injuriesForeign investigationCessna 402B · LittleWhale Cay, BahamasJun 17, 2003 · N3748C · Substantial damage NTSB DCA03WA040Accident · Minor injuriesForeign investigationEelde, NetherlandsJun 17, 2003 · Substantial damage NTSB DCA03WA039Accident · 8 fatalForeign investigationChristchurch, New ZealandJun 6, 2003 · Destroyed NTSB SEA03WA094Accident · Serious injuriesForeign investigationSikorsky S-64F · Bintutu, MalaysiaJun 1, 2003 · N223AC · Destroyed NTSB DCA03WA037Accident · 2 fatalForeign investigationLearjet 45 · Milan, ItalyJun 1, 2003 · I-ERJC · Destroyed NTSB LAX03WA156Accident · No injuriesForeign investigationBeech 200C · Coffs Harbour, AustraliaMay 15, 2003 · VH-AMR · Minor damage NTSB SEA03WA077Accident · 3 fatalForeign investigationPiper PA-46-350 · Lop Buri, ThailandApr 26, 2003 · HS-AKS · Substantial damage NTSB NYC03WA100Accident · No injuriesForeign investigationPiper PA-16 · Saint Girons, FranceApr 25, 2003 · N5900H · Substantial damage NTSB FTW03WA137Accident · 3 fatalForeign investigationGrumman HU-16 · Chetumal, MexicoApr 14, 2003 · N7026Y · Destroyed NTSB FTW03WA130Accident · 4 fatalForeign investigationCessna 182L · Esmeralda, VenezuelaApr 12, 2003 · YV240C · Destroyed