NTSB investigations, 2003
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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\") = 2003 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 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 DEN03LA112Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Glendo, WYthe pilot's failure to maintain clearance from the trees. Factors contributing to the accident were the low altitude, the high density altitude, and the trees.NTSB CHI03LA290Accident · No injuriesLimited investigationFinal reportCessna 172N · Romeo, MIThe pilot not maintaining directional control during landing. A factor to the accident was the parked airplane.NTSB CHI03LA185Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Elk Mound, WIThe pilot's failure to maintain clearance from the terrain. Factors contributing to the accident were the whirlwind, the turbulence, and the helicopter's low altitude.NTSB SEA03LA122Accident · No injuriesLimited investigationFinal reportCessna 185F · Lexington, ORThe pilot's failure to maintain aircraft control during the landing roll. A partially deflated tire and soft terrain were factors.NTSB SEA03LA118Accident · 1 fatalLimited investigationFinal reportHerrin Hornet · Newberg, ORAircraft control not maintained while maneuvering for landing.NTSB NYC03TA138Accident · No injuriesFinal reportAir Tractor 402A · Pearisburg, VAA compressor turbine blade fracture which resulted in a power loss, and forced landing. Factor were the rocks in the landing area, and the operator's decision to operate the engine beyond the engine manufacturer's recommendations for overhaul.NTSB NYC03LA137Accident · No injuriesLimited investigationFinal reportCessna 150F · Williamson, NYThe failure of a rocker arm shaft boss, which resulted in a partial loss of power and subsequent forced landing. A factor was the unsuitable terrain.NTSB MIA03FA135Accident · 2 fatalField investigationFinal reportCessna 414 · N. Fort Myers, FLThe failure of the pilot to maintain airspeed (Vs) following a total loss of engine power from the right engine due to fuel starvation, resulting in an inadvertent stall, uncontrolled descent, and in-flight collision with trees and terrain. Factors in the…NTSB LAX03LA212Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Kualapuu, HIthe total loss of engine power resulting from a fatigue failure of the 3rd stage turbine wheel airfoils. The reason for the airfoil's fatigue failure could not be determined.NTSB LAX03LA211Accident · No injuriesLimited investigationFinal reportPieterse Kitfox 2 · Corona, CAThe improper design and installation of the airplane's fuel system by the builder of the experimental airplane, which resulted in fuel starvation and a loss of engine power.NTSB CHI03FA179Accident · 1 fatalField investigationFinal reportEurocopter EC120B · Boonville, MOThe pilot's inadequate weather evaluation which resulted in his inadvertent flight into instrument meteorological conditions. An additional cause was the pilot's failure to maintain clearance from the terrain. The dark night, thunderstorms, rain and lack of…NTSB SEA03TA116Accident · Minor injuriesFinal reportMcDonnell Douglas 369E · Big Timber, MTFretting on the outside diameter of the compressor coupling adapter which resulted in fatigue and subsequent fracture of the adapter, and ultimately the disconnection of the compressor from the turbine assembly. Contributing factors were low rotor RPM, uneven…NTSB NYC03LA142Accident · No injuriesLimited investigationFinal reportBeech 24 · Rome, NYThe pilot's failure to maintain directional control during a go-around which resulted in the airplane impacting trees. A factor in the accident was the shifting wind.NTSB MIA03LA134Accident · Serious injuriesLimited investigationFinal reportJohn L. Klein Marquart ChargerMA-5 · Pierson, FLSeparation of the elevator push/pull tube from the rear cockpit's control stick for undetermined reasons, which resulted in a loss of elevator control, an uncontrolled descent, and an impact with trees.NTSB FTW03LA177Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Bristow, OKThe pilot's premature retracting of the flaps, and his failure to maintain airspeed which resulted in an inadvertent stall.NTSB CHI03LA182Accident · 1 fatalLimited investigationFinal reportRobinson R-22 Beta · Dexter, MOThe pilot's inadequate visual lookout and failure to maintain clearance from the wires during the aerial application flight. Factors contributing to the accident were the helicopter's low altitude and the transmission wires.NTSB CHI03FA181Accident · 3 fatalField investigationFinal reportRobinson R44 II · Coleta, ILThe pilot not maintaining main rotor RPM during cruise flight. The factor in the two passenger's fatal injuries was the pilot not following directives concerning the prohibition of carrying passengers while a student pilot. Other factors were the pilot's use…NTSB ANC03LA067Accident · 3 fatalLimited investigationFinal reportCessna 180 · Anchor Point, AKAn in-flight collision with water for an undetermined reason.NTSB ANC03FA061Accident · 2 fatalField investigationFinal reportCessna 172 · Skagway, AKThe pilot's continued visual flight into instrument meteorological conditions, which resulted in an in-flight collision with mountainous terrain. Factors associated with the accident were low ceilings, rain, and fog.NTSB ANC03CA088Accident · No injuriesData collectionFinal reportde Havilland DHC-2 · Iliamna, AKThe pilot's incorrect selection of the fuel selector valve position during takeoff which resulted in fuel starvation. A factor associated with the accident was inadequate transition training provided to the pilot by the company/operator management.NTSB NYC03LA135Accident · No injuriesLimited investigationFinal reportEmbraer EMB-135-KL · Boston, MAThe tug driver's failure to maintain directional control of the tug, which caused the tug to impact the airplane.NTSB MIA03LA131Accident · Serious injuriesLimited investigationFinal reportBeech Be-35-33 · Raymond, MSThe loss of engine power for undetermined reasons and the pilot's failure to maintain airspeed resulting in a stall.NTSB DEN03LA110Accident · No injuriesLimited investigationFinal reportAlexander Schleicher · Paragonah, UTThe pilot's encounter with unsuitable terrain during a precautionary landing. Contributing factors were the strong winds and the approaching vehicle.NTSB DEN03FA111Accident · 1 fatalField investigationFinal reportHammond Vans RV-6A · La Junta, COthe pilot's failure to maintain airspeed resulting in a stall during the turn from base leg to final approach.NTSB CHI03LA180Accident · No injuriesLimited investigationFinal reportCessna 170B · Widener, ARThe pilot's failure to maintain clearance from the wires and his failure to maintain adequate airspeed, resulting in a stall. A factor contributing to the accident was the unmarked wires.NTSB NYC03LA134Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Mount Holly, NJA loss of engine power for undetermined reasons.NTSB MIA03FA130Accident · Serious injuriesField investigationFinal reportBoeing 757-232 · Tampa, FLa torching of the right engine caused by an abnormally high flow fuel during engine start for undetermined reasons. The torching resulted in an unwarranted evacuation of the airplane and serious injuries to three passengers . A contributing factor in the…NTSB MIA03CA132Accident · Minor injuriesData collectionFinal reportParsons Trainer · New Smyrna, FLFailure of the pilot to maintain control of the gyrocopter.NTSB LAX03LA209Accident · Serious injuriesLimited investigationFinal reportDavis LG2H · Salome, AZThe pilot's excessive use of the controls during an aborted takeoff, and his failure to maintain airspeed which resulted in a stall/mush. Factors in the accident include the pilot's lack of familiarity with the airplane and an excessively rich mixture setting…NTSB FTW03WA194Accident · Minor injuriesForeign investigationCessna TU-206F · Palencia, GuatemalaNTSB CHI03LA175Accident · No injuriesLimited investigationFinal reportCessna 210M · Carlisle, ARThe pilot's improper in-flight decision to descend for landing, at night, without the runway environment insight. Contributing factors were the pilot's disorientation, the embankment and the dark night condition.NTSB SEA03LA117Accident · No injuriesLimited investigationFinal reportCessna T337D · Driggs, IDThe pilot's inadequate inflight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. A factor contributing to the accident was the unsuitable terrain for the forced landing.NTSB SEA03LA115Accident · No injuriesLimited investigationFinal reportCessna 182C · Bandon, ORLoss of engine power during descent for undetermined reasons.NTSB LAX03WA223Accident · 4 fatalForeign investigationCessna 172 · Cambelltown, AustraliaNTSB LAX03CA208Accident · No injuriesData collectionFinal reportCessna 172K · Overton, NVthe student pilot's failure to maintain an adequate airspeed and his premature raising of the flaps during a go-around, which led to an inadvertent stall/mush. The flight instructor's inadequate supervision of the flight is also causal.NTSB IAD03CA062Accident · No injuriesData collectionFinal reportWilliam Stevens RAF2000 · Stoutsville, OHSeparation of the engine computer wire and connector, which resulted in a partial loss of engine power.NTSB FTW03LA176Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Beaumont, TXThe instructor's delay in executing a go-around and his failure to maintain aircraft control due to inadequate compensation of wind gusts. A contributing factor was the gusty winds.NTSB FTW03LA175Accident · Serious injuriesLimited investigationFinal reportCessna 172L · San Antonio, TXThe pilot misjudged his altitude and airspeed, and his failure to perform a go-around.NTSB DEN03LA109Accident · No injuriesLimited investigationFinal reportAir Tractor AT-802A · Las Vegas, NMthe pilot's failure to maintain obstacle clearance and visual lookout. Contributing factors were his attention being diverted and the trees.NTSB DCA03WA041Accident · 1 fatalForeign investigationCanadair CRJ-100 · Brest, FranceNTSB CHI03LA177Accident · No injuriesLimited investigationFinal reportWaco ARE · Battle Creek, MIThe inadequate material used in the landing gear cross supports leading to its collapse during the landing roll.NTSB ATL03FA111Accident · 3 fatalField investigationFinal reportMaule M-5-235C · Rockvale, TNLoss of engine power for undetermined reasons.NTSB SEA03LA111Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Alzada, MTThe student pilot's failure to maintain adequate flying airspeed in a turn while maneuvering close to the ground resulting in a stall condition. A contributing factor was the turbulent wind conditions.NTSB NYC03LA143Accident · Serious injuriesLimited investigationFinal reportAerostar International RX 8 · Grove City, OHThe passengers failure to maintain her balance inside the balloon basket.NTSB IAD03CA059Accident · No injuriesData collectionFinal reportPiper Saratoga II TC PA32- · Mansfield, OHThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control during the landing. A factor was the gusty wind conditions.NTSB FTW03FA174Accident · 1 fatalField investigationFinal reportCessna 182H · Cushing, OKThe pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin.NTSB CHI03LA173Accident · Serious injuriesLimited investigationFinal reportAerostar S-55A · Monroe, WIThe pilot's failure to maintain clearance from the transmission wires during landing and his decision to jump from the balloon. A factor to the accident was the power transmission lines.NTSB ATL03LA112Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW28 · Batesburg, SCThe loss of thermal lifting action that resulted in the in-flight collision with trees during an attempted forced landing.NTSB ATL03LA110Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Hatteras, NCThe pilot's failure to maintain directional control during the landing roll. A factor was a go-around not performed.NTSB SEA03LA109Accident · No injuriesLimited investigationFinal reportMaule M-7-235C · Moses Lake, WAThe pilot's inadequate compensation for wind conditions during the landing roll. Factors include gusty crosswinds.