Final NTSB investigations, 2003
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\") = 2003
AND c.\"completionStatus\" = 'Completed'
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."completionStatus" = 'Completed' 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 LAX04LA060Accident · No injuriesLimited investigationFinal reportCessna 172S · Watsonville, CAloss of engine power for undetermined reasons.NTSB ATL04TA047Accident · No injuriesFinal reportBell OH-58A · Ruskin, FLLoss of engine power due to undertermined reasons which resulted in a collision with terrain.NTSB NYC04LA044Accident · No injuriesLimited investigationFinal reportSocata TBM 700 · Reading, PAThe pilot's improper decision to not apply de-icing fluid to the wings prior to takeoff, which resulted in snow/ice contamination on the of the wings, a stall mush, and a forced landing in an open field.NTSB CHI04LA040Accident · No injuriesLimited investigationFinal reportClement-Kazmierczak Sorrell SNS-7 · Highmore, SDThe unsuitable terrain for landing encountered by the pilot. Contributing factors were the grass runway surface and the snowbank.NTSB LAX04LA058Accident · No injuriesLimited investigationFinal reportCessna 525 · San Diego, CAThe pilot's failure to maintain directional control and to initiate a timely go-around when visual contact with the runway was lost.NTSB ATL04FA046Accident · 1 fatalField investigationFinal reportAeronca 11AC · San Antonio, FLThe pilot's failure to maintain clearance above objects on approach, which resulted in an in-flight collision with trees and the subsequent collision with terrain.NTSB ATL04FA045Accident · 2 fatalField investigationFinal reportBeech B200 · Morlan, GAThe pilot's inadequate in-flight planning/decision when he continued the flight below the decision height and collided with trees. A related factor was the low ceiling.NTSB ANC04LA012Accident · No injuriesLimited investigationFinal reportCessna 172 · Chugiak, AKThe pilot's selection of an unsuitable landing/takeoff area, and his failure to abort the takeoff, which resulted in an in-flight collision with a stump, and subsequent loss of control. Factors associated with the accident were snow-covered terrain and a…NTSB LAX04LA056Accident · No injuriesLimited investigationFinal reportCessna 172N · Nogales, AZThe student pilot's improper recovery from a bounced landing and his failure to maintain directional control.NTSB LAX04LA055Accident · Minor injuriesLimited investigationFinal reportGoodyear GZ-20A · Gardena, CAThe pilot's delayed go-around during final approach to land, which resulted in an in-flight collision with a fence. A factor associated with the accident is the pilot's failure to maintain adequate altitude/clearance from obstructions.NTSB LAX04FA057Accident · 2 fatalField investigationFinal reportWing D-1 · Rosamond, CAThe flying pilot's failure to obtain/maintain control of the airplane during practice stalls, which resulted in the inadvertent entry into a spin.NTSB FTW04FA036Accident · 2 fatalField investigationFinal reportBeech S35 · Harrison, ARThe pilot's failure to maintain the proper airspeed, which resulted in an inadvertent stall. Contributing factors were the pilot's failure to follow the published instrument approach procedures, and his failure attain the proper glidepath.NTSB NYC04LA043Accident · 1 fatalLimited investigationFinal reportBarness Pulsar I · Bardstown, KYThe pilot's loss of aircraft control, resulting in a subsequent impact with terrain. A factor related to the accident was the pilot's unfamiliarity with the airplane.NTSB LAX04CA063Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Morenci, AZthe pilot's excessive landing flare, which resulted in an improper touchdown and hard landing.NTSB FTW04IA077Incident · No injuriesIncident investigationFinal reportBell BH-212 · Galliano, LAThe loss of tail rotor control due to sheared, loose, and bent bolts which secured the tail rotor pitch control bellcrank support bracket.NTSB DEN04FA027Accident · No injuriesField investigationFinal reportSwearingen SA226-TC · Denver, COthe failure of the pilot of the taxiing aircraft to maintain clearance and adequate visual lookout for the stopped aircraft.NTSB CHI04LA039Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Pontiac, MIThe loss of engine power for undetermined reasons. A factor to the accident was the tree line and the unsuitable terrain.NTSB ATL04LA044Accident · Minor injuriesLimited investigationFinal reportCessna 182-K · Birmingham, ALA loss of engine power due to the throttle/power lever cable becoming disconnected in-flight, as a result of maintenance personnel failure to comply with Airworthiness Directive (AD) 86-24-07 and Cessna information letter SE79-6.NTSB SEA04LA024Accident · 1 fatalLimited investigationFinal reportShear Titan Tornado · Brooks, ORThe failure of the pilot to maintain aircraft control while maneuvering due to a hypoglycemic condition.NTSB NYC04LA042Accident · No injuriesLimited investigationFinal reportCanadair CL-600-2B19 · Jamaica, NYAn encounter with an unoccupied belt loader, after the belt loader driver inadvertently fell to the ground while maneuvering. Factors in this accident were the gusty wind conditions and the failure of the operator to require that persons operating belt…NTSB NYC04LA041Accident · Minor injuriesLimited investigationFinal reportRussell Cozy MK III · Holbrook, NYThe pilot's improper fuel management, which resulted in fuel starvation and subsequent loss of engine power.NTSB FTW04LA031Accident · No injuriesLimited investigationFinal reportCessna 310-H · Oklahoma City, OKThe pilot's mismanagement of the fuel by which he failed to position the fuel selector on the appropriate fuel tanks resulting in fuel starvation. A contributing factor was the pilot's diverted attention.NTSB FTW04FA029Accident · 1 fatalField investigationFinal reportBell 407 · High Island 573The loss of engine power due to the failure of the 3rd stage turbine wheel and subsequent catastrophic failure of the turbine assembly.NTSB IAD04LA003Accident · No injuriesLimited investigationFinal reportCessna C172R · Lexington, KYThe ground controller's failure to advise the relieving controller information regarding an engine run-up, which subsequently resulted in the flight instructor's inadvertent encounter with jet blast during ground taxi.NTSB DEN04LA025Accident · No injuriesLimited investigationFinal reportCessna T210K · Deming, NMThe pilot's improper in-flight planning and decision. Factors contributing to the accident were fuel exhaustion and the fence.NTSB CHI04LA035Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Bloomfield, IAThe pilot's inadequate compensation for the crosswind condition which resulted in his failure to maintain directional control of the airplane. Factors associated with the accident were the crosswind and the grass which the airplane contacted.NTSB SEA04FA023Accident · 1 fatalField investigationFinal reportFairchild Swearingen SA227-AT · Spokane, WAThe pilot-in-command's failure to maintain proper glidepath alignment during an ILS approach in poor weather resulting in collision with trees and terrain. Contributing factors were the unreliable status of the primary (NAV 1) ILS receiver (leaving the pilot…NTSB LAX04LA054Accident · No injuriesLimited investigationFinal reportCessna 172S · Wikieup, AZThe pilot's selection of an en route altitude that did not provide adequate terrain clearance, and resulted in the in-flight collision with terrain. The rising terrain and the blind/box canyon were contributing factors.NTSB FTW04LA069Accident · No injuriesLimited investigationFinal reportMBB BK 117 B-2 · Conroe, TXThe pilot's failure to maintain clearance from trees while repositioning in a confined landing zone. Contributing factors were the dark night light conditions and the confined area available to the pilot.NTSB FTW04CA030Accident · Minor injuriesData collectionFinal reportBell 206L1 · Paris, ARThe pilot's failure to remove the main rotor tiedown prior to engine startup. Contributing factors were the pressure induced by conditions/events, improper preflight of the aircraft, and dark night conditions,NTSB DEN04IA026Incident · No injuriesIncident investigationFinal reportBoeing 737-3M8 · Denver, COThe restricted movement of the flight control yoke and tiller wheel steering for reasons undetermined.NTSB ANC04LA010Accident · No injuriesLimited investigationFinal reportdeHAVILLAND DHC-2 · Kodiak, AKThe pilot's inadequate evaluation of the weather conditions, and his failure to maintain adequate altitude/clearance, which resulted in a collision with terrain during the final landing approach. A factor contributing to the accident was the presence of a…NTSB MIA04FA029Accident · 1 fatalField investigationFinal reportSwearingen SA-26-AT · Jacksonville, FLThe pilot's descent below decision height while performing an ILS approach with low ceilings and fog, resulting in an in-flight collision with trees and the ground. A factor associated with the accident was the pilot's decision to attempt the instrument…NTSB NYC04LA039Accident · Minor injuriesLimited investigationFinal reportBell 206B · Cranston, RIThe pilot's inadvertent encounter with loss of tail rotor effectiveness. A factor was the wind change.NTSB FTW04LA028Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Wichita Falls, TXThe loss of engine power due to an obstruction in the fuel line.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 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 CHI04LA036Accident · No injuriesLimited investigationFinal reportCessna 182R · Wausau, WIThe pilot 's improper flare which resulted in a hard landing, and the flight instructors inadequate supervision.