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 SEA03LA158Accident · No injuriesLimited investigationFinal reportHughes 269C · Melba, IDThe pilot's failure to maintain control of the helicopter due to his failure to maintain rotor rpm. Factors contributing to the accident were the corn crop, and the pilot's abrupt maneuver to avoid obstacles.NTSB SEA03LA157Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-24E · Hood River, ORThe pilot's failure to refuel prior to the flight, resulting in fuel exhaustion during the initial climb, followed by the pilot's failure to maintain airspeed. An inadvertent stall was a factor.NTSB MIA03LA150Accident · 1 fatalLimited investigationFinal reportTurkan Delta Wing Kite Trik · Odessa, FLThe pilot's improper assembly and failure to connect a bolt following an attempted modification that resulted in airframe malfunction, and uncontrolled descent, and an impact with the ground.NTSB CHI03LA232Accident · No injuriesLimited investigationFinal reportAmerican Champion 8KCAB · Stephen, MNThe pilot's failure to maintain clearance from the transmission line and the pilot's continued operation with known deficiencies in equipment. Factors to the accident were the power lines and the low altitude the pilot was flying at.NTSB CHI03LA178Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Buffalo, SDThe instructor pilot's inadequate remedial action to the dual student's loss of aircraft control during high speed taxiing which lead to the inadvertent ground loop/swerve. A factor was the student not maintaining aircraft control.NTSB SEA03CA155Accident · Minor injuriesData collectionFinal reportCessna 170B · Schafer, MTThe pilot's delayed remedial action during the takeoff roll. Factors include wet terrain, a fence and an embankment located at the end of the runway.NTSB LAX03LA245Accident · Minor injuriesLimited investigationFinal reportHogarty Lancair IV P · North Las Vegas, NVThe pilot's premature lift-off before airspeed was attained resulting in a stall. A factor associated with the accident was a high density altitude.NTSB CHI03LA227Accident · 1 fatalLimited investigationFinal reportUllrich Auriga FT · Aberdeen, SDA loss of engine power due to the lack of design fuel pressure for undetermined reasons.NTSB CHI03LA226Accident · No injuriesLimited investigationFinal reportCessna 177 · Murdock, NEThe pilot's inadequate preflight planning/preparation which led to fuel exhaustion and subsequent loss of engine power. Contributing to the accident were the trees and unsuitable terrain.NTSB SEA03LA154Accident · Serious injuriesLimited investigationFinal reportBollinger RV-6A · Wenatchee, WAFuel starvation following the separation of a purge valve assembly as a result of the builders failure to re-safety the face retaining/stop screw on the fuel vapor purge valve after the safety wire on the subject screw was removed in order to change the…NTSB SEA03GA153Accident · 1 fatalFinal reportKaman K-1200 · Keller, WACorrosion fatigue within the blade retention bolt bushing(s) of the main rotor blade grip resulting in fatigue, cracking and ultimate separation of the upper grip plate. The separation of the upper blade grip plate led to a dynamic imbalance within the rotor…NTSB NYC03LA168Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Rhinebeck, NYA loss of engine power due to a failure of the number eight cylinder.NTSB LAX03GA244Accident · 2 fatalFinal reportBell 206L-3 · Whiteriver, AZThe pilot's failure to maintain a minimum translational lift airspeed while maneuvering in high density altitude conditions at near maximum required torque and above the in ground effect hover altitude, that resulted in a loss of tail rotor effectiveness and…NTSB LAX03CA257Accident · No injuriesData collectionFinal reportLancair 235 · Page, AZThe pilot's misjudged landing flare, which resulted in a hard landing and his improper recovery from a bounced landing. Inadvertent entry into a porpoise pilot-induced oscillation, and high density altitude were contributing factors.NTSB IAD03CA068Accident · Minor injuriesData collectionFinal reportAero Commander 100 · Fulton, KYThe malfunction of the brake system and the pilot's delay in aborting the landing.NTSB DEN03FA136Accident · 4 fatalField investigationFinal reportMooney M20C · Blanding, UTthe pilot's failure to maintain airspeed which resulted in a stall/spin.NTSB CHI03LA228Accident · Minor injuriesLimited investigationFinal reportFerence Varieze · Macomb, MIThe pilot's failure to secure the window canopy before takeoff and his failure to maintain directional control which resulted in a loss of control. The pilot's diverted attention is a contributing factor.NTSB ATL03LA120Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA-5A · Canon, GAThe loss of engine power due to water and corrosion in the fuel system. A factor was the collision with a ditch.NTSB SEA03LA156Accident · No injuriesLimited investigationFinal reportHughes 269C · Marblemount, WAThe partial failure of a magneto during hover taxi over water, leading to a forced landing in shallow water near the shoreline. Factors include the aircraft being over a lake at the time that the partial loss of power made it impossible to keep it airborne.NTSB NYC03LA166Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Newburyport, MAThe pilot's inadequate compensation for the wind conditions and his inadequate flare.NTSB NYC03LA165Accident · No injuriesLimited investigationFinal reportBeltram Glasair-TD · London, KYThe pilot's failure to follow published procedures, which resulted in fuel starvation during approach.NTSB NYC03CA167Accident · No injuriesData collectionFinal reportCessna 172P · Plainfield, CTThe pilot's failure to maintain directional control, which resulted in a collision with a ditch. A factor in this accident was the crosswind condition.NTSB MIA03LA149Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Plantation, FLThe pilot's improper preflight planning and failure to refuel before the flight, which resulted in fuel exhaustion, a forced landing and damage to the airplane during the landing.NTSB MIA03CA151Accident · No injuriesData collectionFinal reportAircraft Mfg & Dev. CH2T · Crystal River, FLThe student pilot 's failure to maintain control while landing in crosswind which resulted in airplane departing the runway and incurring damage.NTSB MIA03CA148Accident · No injuriesData collectionFinal reportCessna 172S · Olive Branch, MSThe student pilot's improper landing flare/touchdown and inadequate recovery from a bounced landing which resulted in a hard landing and damage to the airplane.NTSB CHI03LA229Accident · No injuriesLimited investigationFinal reportCessna 172P · Huntingburg, INThe pilot's inadequate flare and the failure to perform a go-around during landing. The planned approach with a quartering tailwind were contributing factors.NTSB CHI03LA225Accident · No injuriesLimited investigationFinal reportBeech C23 · Madison, WIThe dual student's delay in executing the aborted takeoff. Also causal was the pilot-in-command's delayed remedial action.NTSB SEA03LA151Accident · No injuriesLimited investigationFinal reportHughes 269C · Snohomish, WAThe dual students failure to maintain clearance from the terrain during the go-around from a simulated autorotational flare, and the instructor pilot's failure to take adequate remedial action to keep the dual student from allowing the aircraft to impact the…NTSB LAX03LA243Accident · No injuriesLimited investigationFinal reportBeech V35B · Livermore, CAThe pilot's inadequate fuel management, which resulted in fuel starvation and a loss of engine power during cruise flight.NTSB LAX03LA242Accident · Minor injuriesLimited investigationFinal reportSmith Miniplane · Winnemucca, NVThe pilot's failure to refuel the airplane prior to fuel exhaustion, which resulted in a loss of engine power during cruise flight, and subsequent in-flight collision with terrain. A factor associated with the accident is the night light conditions.NTSB CHI03LA230Accident · No injuriesLimited investigationFinal reportMurch Rotec Rally 3 · Searcy, ARThe frayed rudder cable that failed during the turn to final. A factor was the ditch the airplane encountered during the forced landing.NTSB CHI03LA223Accident · No injuriesLimited investigationFinal reportCessna 172H · Red Wing, MNThe pilot's failure to follow the checklist resulting in fuel starvation and subsequent loss of engine power.NTSB CHI03LA220Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Evansville, INThe pilot's failure to attain the proper touchdown point. The barrels were a factor.NTSB SEA03LA149Accident · No injuriesLimited investigationFinal reportCessna 182C · Cashmere, WAThe pilot in command's misjudgment of distance and speed, and his failure to execute a go-around. A contributing factor was the fence.NTSB MIA03WA159Accident · 1 fatalForeign investigationCessna 551 · Sorocaba, BrazilNTSB LAX03LA240Accident · Minor injuriesLimited investigationFinal reportCessna 180C · Punkin Center, AZThe pilot's inadequate preflight planning and failure to attain adequate climb rate to ensure clearance from obstacles. The tailwind and high density altitude were factors.NTSB LAX03FA241Accident · 5 fatalField investigationFinal reportBell 206B · Waialeale,Kauai, HIThe pilot's failure to maintain adequate terrain clearance/altitude while descending over mountainous terrain, and his continued flight into adverse weather. Factors contributing to the accident were clouds and a low ceiling.NTSB CHI03LA224Accident · Serious injuriesLimited investigationFinal reportAerostar S81A · Highland, MIFailure of the pilot to maintain a proper descent rate. Contributing factors were the pilot's failure to maintain clearance from the trees, the reported high winds and gusts, the trees, the power lines and the house.NTSB SEA03FA148Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Tulalip, WAA loss of control for unknown reasons.NTSB SEA03FA147Accident · No injuriesField investigationFinal reportCessna Citation 525 · Coupeville, WAThe loss of airplane pitch control (trim runway and mistrim condition) resulting from a failure in the airplane's electric pitch trim system. Factors that contributed to the accident were the manufacturer's inadequate design of the pitch trim circuitry that…NTSB NYC03FA164Accident · 1 fatalField investigationFinal reportHawker T Mk 7A · Pittston, PAThe pilot's failure to abort the takeoff, after the engine experienced a partial power loss for undetermined reasons. Factors were the pilot's improper preflight planning by his failure to determine if the airplane was airworthy, and the operators inadequate…NTSB NYC03CA169Accident · Serious injuriesData collectionFinal reportBoeing 757-251 · Wadsworth, OHAn in-flight encounter with turbulence.NTSB LAX03LA239Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Hamilton City, CAThe pilot's failure to maintain adequate airspeed to avert stalling during a low altitude turn.NTSB DEN03LA135Accident · No injuriesLimited investigationFinal reportCessna A185F · Angel Fire, NMthe instructor's inadequate supervision which resulted in the pilot's loss of directional control and the subsequent impact with the ditch. Contributing factors include the instructor's inadequate remedial action and the inadvertent ground loop/swerve.NTSB CHI03LA221Accident · Minor injuriesLimited investigationFinal reportNavion L-17A · Canton, ILA complete loss of engine power during landing approach for undetermined reasons, as well as the unsuitable terrain for a forced landing encountered by the pilot. Contributing factors were the berm and the crops.NTSB SEA03WA159Accident · No injuriesForeign investigationHughes 369D · Powell River BC, CanadaNTSB SEA03LA152Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Hermiston, ORThe pilot's inadequate in-flight decision by failing to refuel, resulting in fuel exhaustion and the loss of power. Rocky terrain was a factor.NTSB SEA03LA146Accident · No injuriesLimited investigationFinal reportCessna 182S · Henry's Lake, IDA set of inadequately torqued vacuum pump retaining nuts, leading to the failure of the vacuum pump gasket, resulting in oil exhaustion, which resulted in a loss of engine power during cruise. A ditch and rough uneven terrain were factors.NTSB SEA03CA144Accident · Minor injuriesData collectionFinal reportWSK PZL Mielec PZL-M-18 · Burley, IDThe pilot's failure to remove the elevator gust lock prior to flight. Factors include the pilot's inadequate preflight.NTSB IAD03LA066Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Hampton Bays, NYA loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.