NTSB investigations, 2003
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 CHI04LA037Accident · No injuriesLimited investigationFinal reportAmerican Champion 7GCBC · Menominee, MIThe Phillips screwdriver impacting the left tire on takeoff roll, and the deflated tire which did not allow directional control to be maintained during the subsequent landing.NTSB ATL04CA041Accident · No injuriesData collectionFinal reportGlobe Swift GC1B · Southern Pines, NCThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent ground loop and the collapse of the landing gear.NTSB SEA04FA022Accident · 4 fatalField investigationFinal reportBeech S35 · Warren, ORThe vacuum pump failure and the pilot's failure to maintain control of the airplane. Factors contributing to the accident included the instrument meteorological weather conditions and the pilot's improper recovery from the descent.NTSB NYC04LA086Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Kutztown, PAThe pilot's inadvertent retraction of the landing gear on the ground.NTSB LAX04TA052Accident · No injuriesFinal reportEurocopter France AS 350 B3 · Yuma, AZThe malfunction of the rotor drive system due to improper maintenance, which resulted in the uncoupling of the drive shaft during takeoff-initial climb. A factor associated with the accident is the undertorqued drive system bolts.NTSB FTW04IA043Incident · No injuriesIncident investigationFinal reportBell 206B · Venice, LAThe failure of the forward boost pump while in cruise flight while operating with less than 10 gallons of fuel onboard, which resulted in a loss of engine power. A factor was the inoperative forward fuel boost pump caution light switch.NTSB ATL04IA048Incident · No injuriesIncident investigationFinal reportCessna 560XL · Savannah, GAThe malfunction of the nose wheel gear for undetermined reasons.NTSB LAX04LA053Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Fountain Hills, AZThe flight instructor's delayed remedial action and inadequate altitude during a go-around following a simulated forced landing, which resulted in an in-flight collision with terrain.NTSB CHI04LA038Accident · No injuriesLimited investigationFinal reportCessna 340A · Poplar Bluff, MOFailure to maintain directional control during landing. Collapse of the nose landing gear, the muddy grass/turf and the berm were contributing factors.NTSB ANC04LA009Accident · No injuriesLimited investigationFinal reportBeech 1900C · Juneau, AKThe pilot's failure to maintain altitude/clearance from obstacles when approaching the airport, which resulted in an in-flight collision with a tree. Factors associated with the accident were the dark night, snow showers, and the pilot's failure to maintain…NTSB SEA04LA021Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Emmett, IDBrake failure as a result of inadequate hydraulic (brake) fluid in the aircraft's closed brake system. Contributing factors were the pilot's overall lack of experience in the aircraft make/model, the cold soaked brake system due to the low temperatures, and…NTSB NYC04LA040Accident · No injuriesLimited investigationFinal reportBeech H-18 · Westminster, MDThe pilot's failure to maintain control of the airplane after a failure of one propeller system. Factors in the accident were the failure to perform maintenance inspection and the failure of a bolt in the left propeller blade system.NTSB NYC04LA038Accident · No injuriesLimited investigationFinal reportCessna 182Q · Tunkhannock, PAThe pilot's misjudgment of distance resulting in an overrun.NTSB MIA04WA030Accident · 4 fatalForeign investigationPiper PA-28R-201T · Caracas, VenezuelaNTSB LAX04GA051Accident · 2 fatalFinal reportPiper PA-28-180 · Big Bear City, CAThe pilots inadequate preflight planning and intentional flight into known adverse weather conditions. Contributing to this accident was the fact that it was a dark night with no moon illumination.NTSB FTW04WA033Accident · 2 fatalForeign investigationBeech BE-36 · Santa Cruz, BoliviaNTSB CHI04LA036Accident · No injuriesLimited investigationFinal reportCessna 182R · Wausau, WIThe pilot 's improper flare which resulted in a hard landing, and the flight instructors inadequate supervision.NTSB ATL04LA040Accident · No injuriesLimited investigationFinal reportCessna 172 · Hickory, NCThe CFI inadequate supervision, and failure to maintain directional control during the attempted touch-and-go landing.NTSB ATL04LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Columbia, SCThe pilot's mismanagement of the fuel supply, and his inadequate preflight planning which resulted in fuel exhaustion.NTSB MIA04FA023Accident · 3 fatalField investigationFinal reportBeech G35 · Okolona, MSThe pilot's intentional low altitude maneuver and buzzing resulting in collision with trees, uncontrolled descent, and in-flight collision with terrain. A factor in the accident was the pilot's ostentatious display.NTSB MIA04CA028Accident · No injuriesData collectionFinal reportCessna 172S · Orlando, FLThe student pilots improper landing flare and his improper recovery from a bounced landing resulting in a hard landing and damage to the airplane.NTSB FTW04WA032Accident · 2 fatalForeign investigationCessna P337 · Versalles, BoliviaNTSB FTW04LA027Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Sweetwater, TXthe loss of engine power due to a failure of the crankshaft bolt. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW04LA026Accident · Minor injuriesLimited investigationFinal reportCessna 172N · La Grange, TXThe pilot's failure to properly navigate during the day VFR cross-country flight, which resulted in the pilot becoming disoriented.NTSB CHI04LA034Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Superior, WIThe pilot's failure to maintain directional control of the airplane during the landing roll. Factors associated with the accident were the ditch that the airplane contacted.NTSB ATL04FA038Accident · 1 fatalField investigationFinal reportBeech 55 · Griffin, GAA loss of engine power due to the pilot's failure to follow the engine failure after liftoff emergency procedure to feather the left engine propeller resulting in a loss of control during climbout, and the subsequent collision with a commercial building. A…NTSB SEA04LA019Accident · 1 fatalLimited investigationFinal reportKaman K-600 · Nordman, IDThe total failure of the helicopter's right main rotor shaft while in an ascending hover due to the propagation of a fatigue crack that initiated in a corrosion pit on the surface of a slot in the wall of the subject shaft. Factors include accumulation of…NTSB SEA04FA020Accident · 1 fatalField investigationFinal reportCessna T210N · Bellevue, IDThe pilot's failure to maintain adequate altitude above mountainous terrain while maneuvering during descent. Factors included the mountainous terrain, the high wind condition, and dark night light conditions.NTSB NYC04FA036Accident · 3 fatalField investigationFinal reportBeech J35 · Somerset, KYA total loss of engine power during takeoff for undetermined reasons. A factor was the impairment of the pilot in command due to an over-the-counter antihistamine.NTSB LAX04LA049Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Phoenix, AZthe flight instructor's inadequate supervision of the flight and delayed remedial action, which resulted in a loss of directional control. The reason for the partial power loss in the left engine was not determined.NTSB FTW04FA025Accident · 2 fatalField investigationFinal reportBeech A45 · Montgomery, TXThe non-compliance with applicable Airworthiness Directives which required wing spar inspections, and the continued operation of the aircraft beyond the compliance time extension granted as per the approved alternate means of compliance (AMOC). Also causal…NTSB SEA04LA018Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-2 · Monmouth, ORFatigue failure of a tail rotor blade during hover operations.NTSB NYC04IA037Incident · No injuriesIncident investigationFinal reportDassault-Breguet Falcon 50 · Windsor Locks, CTAn in-flight fire, originating from electrical arcing, which subsequently created a hole in an oxygen line.NTSB MIA04LA024Accident · Serious injuriesLimited investigationFinal reportBeech BE-76 · Daytona Beach, FLThe pilot's improper starting procedure which led to inadvertent activation of the propeller.NTSB LAX04CA048Accident · No injuriesData collectionFinal reportRobinson R22 · Chandler, AZthe student pilot's failure to maintain control of the helicopter while hovering. A factor to the accident was the student pilot's lack of experience.NTSB FTW04FA024Accident · Serious injuriesField investigationFinal reportCessna 550 · Mineral Wells, TXThe pilot-in-command's failure to maintain control of the airplane while executing a simulated engine failure on final approach. A factor was the windshear.NTSB DEN04LA023Accident · No injuriesLimited investigationFinal reportFairchild Swearingen SA226TC · Grand Junction, COthe operator's improper maintenance and servicing of the airplane's nose landing gear assembly, resulting in the collapse of the nose landing gear during the landing roll. Contributing factors include the nose section of the airplane's subsequent contact with…NTSB CHI04LA032Accident · Serious injuriesLimited investigationFinal reportHughes TH-55A · West Lafayette, INThe fractured cluster fitting resulting in a loss of directional control during initial climb and the improper repair of cluster fitting by unknown personnel. The night conditions were a contributing factor.NTSB LAX04LA047Accident · Minor injuriesLimited investigationFinal reportBeech A36TC · Visalia, CAa loss of engine power for undetermined reasons.NTSB LAX04LA046Accident · Serious injuriesLimited investigationFinal reportSuminski Cozy Long Ez · Maui, HIThe loss of engine power during cruise flight for an undetermined reason, which resulted in an emergency descent and ditching.NTSB NYC04LA035Accident · 1 fatalLimited investigationFinal reportNortham RAF 2000 · Nelsonia, VAA loss of control for undetermined reason(s).NTSB NYC04FA033Accident · 2 fatalField investigationFinal reportCessna 180 · Westerly, RIThe Piper pilot's improper decision to continue a landing on an occupied runway, which resulted in an in-flight collision with the departing Cessna. Factors related to the accident were the departing Cessna pilot's inattentive radio communications, and the…NTSB FTW04IA023Incident · No injuriesIncident investigationFinal reportBell 407 · Eugene Is. 27The loss of engine power due to the failure of the 3rd stage turbine wheel and subsequent catastrophic failure of the turbine assembly.NTSB FTW04FA022Accident · 1 fatalField investigationFinal reportCessna 210M · Tolar, TXThe pilot's improper pre-flight planning and loss of engine power for undetermined reasons. A factor was the fog.NTSB MIA04LA022Accident · No injuriesLimited investigationFinal reportHughes OH-6A · Brooksville, FLA loss of engine power due to the pilot's failure to adequately plan for the flight which resulted in fuel exhaustion, a forced landing, and damage to the helicopter during the landing.NTSB MIA04CA025Accident · No injuriesData collectionFinal reportCessna 152 · Ormond Beach, FLThe student pilot improper recovery from a bounced landing, which resulted in a hard landing and damage to the airplane.NTSB LAX04LA045Accident · Serious injuriesLimited investigationFinal reportOMF OMF-100-160 · Van Nuys, CAthe pilot's failure to either brief the passenger about disembarking from an airplane with the propeller running or to shutdown the engine during the passenger's disembarkation. The night lighting condition and the passenger's lack of familiarity with…NTSB ATL04LA037Accident · No injuriesLimited investigationFinal reportHughes OH-6A · Greenville, SCThe pilot's improper landing flare, resulting in a hard landing and a main rotor/tailboom strike.NTSB ATL04LA036Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Suches, GAThe pilot's failure to maintain airspeed during a go-round that resulted in an inadvertent stall and the subsequent collision with trees.NTSB LAX04LA050Accident · No injuriesLimited investigationFinal reportBoeing 747-422 · San Francisco, CAa tail strike due to a combination of the wind shifting from a headwind to a tailwind during rotation, and the pilot's control inputs for the crosswind condition.