NTSB investigations, 2003
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.
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 MIA03FA065Accident · 1 fatalField investigationFinal reportAerofab Lake 250 · Weirsdale, FLThe inadequate flare by the pilot-in-command on the calm water resulting in the in-flight collision with the water and subsequent nose over.NTSB FTW03LA112Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS-350-B3 · Clyde, TXthe pilot's delayed remedial action and his continued flight into known adverse weather conditions. A contributing factor was the excessive descent rate which resulted in a hard landing.NTSB CHI03LA074Accident · 1 fatalLimited investigationFinal reportNorth American/Aero Classics P-51D · Urbana, INThe pilot's failure to maintain aircraft control which resulted in a spin.NTSB NYC03LA048Accident · No injuriesLimited investigationFinal reportCessna 172SP · Flemington, NJThe manufacturer's improper assembly of the accessory drive section of the engine.NTSB LAX03FA090Accident · Serious injuriesField investigationFinal reportCessna 172P · Santa Susana, CAThe flight instructor's inadequate in-flight decision to cross mountainous terrain at a inadequate altitude to guarantee terrain clearance.NTSB FTW03LA100Accident · No injuriesLimited investigationFinal reportCessna 172K · Jacksonville, TXThe pilot's inadequate preflight planning and preparation for the flight which resulted in a loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW03LA099Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta II · Kent, TXThe loss of main rotor drive due to a drive belt separation resulting in a forced landing. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW03LA098Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Holly Grove, ARThe pilot's failure to abort the takeoff.NTSB CHI03LA072Accident · No injuriesLimited investigationFinal reportBeech V35 · Sparta, MIThe pilots improper decision to fly into known adverse weather, and his failure to maintain airspeed which resulted in an inadvertent stall. A contributing factor was airframe icing.NTSB ATL03LA047Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Valdosta, GAThe pilot's failure to maintain adequate airspeed during a go-around resulting in an inadvertent stall and collision with trees.NTSB ATL03LA046Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Morristown, TNThe pilot's inadequate preflight planning/decision to initiate flight into known adverse weather conditions, resulting in the in-flight encounter with weather and subsequent in-flight collision with terrain. A factor was airplane performance deteriorated due…NTSB MIA03LA061Accident · 4 fatalLimited investigationFinal reportPiper PA-23-250 · Miami, FLThe non instrument-rated pilot-in-command's improper inflight planning/decision, and continued VFR flight into instrument meteorological conditions, which resulted in a loss of control during descent, and impact with water.NTSB IAD03FA032Accident · 3 fatalField investigationFinal reportCessna 421 · Ferguson, KYThe pilot's failure to follow the instrument approach procedure, which resulted in an early descent into trees and terrain. Factors included the low ceiling and the night lighting conditions.NTSB NYC03LA055Accident · No injuriesLimited investigationFinal reportCessna 140 · Fryeburg, MEAn in-flight encounter with carburetor ice, which resulted in a total loss of engine power during a simulated engine failure.NTSB NYC03LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Taylor Mill, KYThe pilot's inaccurate in-flight planning and fuel consumption calculations, and his improper decision not to land and refuel.NTSB LAX03LA089Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Stockton, CAfuel starvation due to the pilot's mismanagement of the fuel supply and failure to verify the fuel quantity on board at departure.NTSB LAX03LA088Accident · No injuriesLimited investigationFinal reportCessna 421C · San Francisco, CAThe vehicle driver's inadequate visual lookout and failure to follow established procedures. A contributing factor was the dark nighttime condition.NTSB FTW03FA097Accident · 2 fatalField investigationFinal reportBell 407 · Mi 700The catastrophic failure of the engine resulting from 1st stage turbine wheel blade failure due to type 1 hot corrosion (sulfidation). Contributing factors were the pilot's failure to brief the passengers on emergency safety equipment (life raft), the pilot's…NTSB CHI03LA077Accident · No injuriesLimited investigationFinal reportSwearingen SA-26AT · Cahokia, ILThe pilot failed to maintain directional control of the airplane during landing. Factors associated with the accident were the snow covered runway, the crosswind, and the overload failure of the nose gear.NTSB LAX03LA099Accident · No injuriesLimited investigationFinal reportAerostar International S-71A · Scottsdale, AZthe pilot's inadequate in-flight decision to cross over four sets of power lines with the existence of a known low fuel state and lack of wind, and failure to maintain altitude/clearance from the power lines during the landing, which resulted in the envelope…NTSB IAD03LA033Accident · Serious injuriesLimited investigationFinal reportRotorway Exec 162F · Westford, MAThe inflight loss of control due to the loss of tail rotor effectiveness.NTSB DEN03LA043Accident · No injuriesLimited investigationFinal reportSocata TBM 700 · Aspen, COthe dual student's failure to maintain aircraft control and the inadequate supervision by the flight instructor. Contributing factors include the tailwind and the turbulence.NTSB CHI03IA070Incident · No injuriesIncident investigationFinal reportCanadair CRJ-600 · Bloomington, ILThe pilot's improper in-flight decision to land on a runway with a tailwind component that exceeded the airplane's tailwind limitation and his failure to perform a go-around which resulted in the proper touchdown point not being attained and the airplane…NTSB CHI03FA071Accident · 1 fatalField investigationFinal reportCessna 172N · Wellington, KSSpatial disorientation experienced by the pilot and his subsequent failure to maintain control of the aircraft. Contributing factors were the pilot's failure to obtain an updated preflight weather briefing prior to the return flight, his attempted flight into…NTSB MIA03IA062Incident · No injuriesIncident investigationFinal reportCessna 500 · Fort Lauderdale, FLInadequate quality control following overhaul of the high-pressure compressor (HPC) impeller by other maintenance personnel that resulted in a machining groove on the aft face of the HPC impeller being undetected, which resulted in a fatigue fracture and an…NTSB CHI03LA073Accident · No injuriesLimited investigationFinal reportCessna 172 · Clare, MIThe student pilot failed to maintain directional control of the airplane during takeoff roll. A factor was the snow bank.NTSB SEA03LA039Accident · No injuriesLimited investigationFinal reportKesterson Nieuport 11 · Independence, ORAircraft control not maintained during takeoff. Factors include soft/muddy terrain.NTSB ENG03WA007Incident · No injuriesForeign investigationBoeing 747 · Okinawa, JapanNTSB ENG03RA010Accident · Minor injuriesForeign investigationCessna 208 · Caqueta Province, ColombiaNTSB CHI03IA069Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Goodland, KSThe partial loss of engine power to both engines for undetermined reasons, and the pilot's improper in-flight decision to not land at the nearest available airport.NTSB ATL03LA045Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Bolivar, TNThe loss of engine power for undetermined reasons. A factor was trees.NTSB MIA03LA057Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Pompano Beach, FLThe student pilot's failure to maintain control during takeoff which resulted in in uncontrolled descent and the helicopter impacting the ground.NTSB MIA03LA056Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Leesburg, MSThe pilot's improper use of flaps, resulting in the degradation of climb performance and collision with the ground.NTSB ENG03RA008Accident · No injuriesForeign investigationRobinson R44 · Mareeba Aerdrome, AustraliaNTSB IAD03WA067Accident · No injuriesForeign investigationAgusta A-109E · Ikaria Island, GreeceNTSB CHI03LA068Accident · No injuriesLimited investigationFinal reportCessna 182F · Estherville, IAThe pilot failed to maintain adequate control of the airplane while taxiing in high wind conditions. A factor was the high winds.NTSB ATL03LA044Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Hendersonville, NCThe pilot's failure to maintain directional control and clearence from power lines during a go-around, resulting in an in-flight collision with a powerline.NTSB ANC03LA028Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Sitka, AKThe 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 right main landing gear.NTSB ANC03LA027Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Soldotna, AKThe pilot's selection of unsuitable terrain for takeoff, and his failure to maintain aircraft control which resulted in a nose over. A factor contributing to the accident was standing puddles of water on the frozen lake.NTSB LAX03LA087Accident · Minor injuriesLimited investigationFinal reportCessna 182A · The Gap, AZA total loss of engine power for undetermined reasons.NTSB ANC03LA026Accident · No injuriesLimited investigationFinal reportHughes 369E · Paxson, AKThe pilot's failure to maintain altitude/clearance from terrain. A factor contributing to the accident was the pilot's attention being diverted inside the cockpit to look at the global positioning system.NTSB SEA03LA037Accident · No injuriesLimited investigationFinal reportCessna 172S · Everett, WAThe pilot's failure to maintain adequate airspeed and the instructor's inadequate supervision of the flight. Contributing factors were the rime icing conditions, and the soft terrain encountered on the off runway rollout.NTSB NYC03LA050Accident · No injuriesLimited investigationFinal reportCessna 182R · Warwick, NYThe pilot's inadequate compensation for winds, and his failure to maintain the proper descent rate. A factor in the accident was the gusty wind conditions.NTSB MIA03FA054Accident · Serious injuriesField investigationFinal reportCessna 170A · Davie, FLThe pilot's improper preflight planning and his inadequate in-flight planning decision which resulted in loss of engine power due to fuel exhaustion and collision with wires and a road during the subsequent forced landing.NTSB FTW03LA095Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Lockhart, TXThe pilot's failure to compensate for the existing wind conditions. A contributing factor was the prevailing crosswind.NTSB CHI03LA067Accident · No injuriesLimited investigationFinal reportBeech BE-G35 · Urbana, ILThe partial failure of the left stabilizer in overload.NTSB ATL03LA043Accident · Serious injuriesLimited investigationFinal reportPenska Rans S-9 · Dothan, ALThe pilot's failure to maintain adequate airspeed which resulted in a stall and subsequent inflight collision with the groundNTSB SEA03LA036Accident · No injuriesLimited investigationFinal reportCessna 172N · McMinnville, ORThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control during the landing roll. Factors include gusty crosswinds and soft terrain in the area where the aircraft departed the side of the runway.NTSB SEA03FA038Accident · No injuriesField investigationFinal reportBeech A23 · Fort Klamath, ORThe separation of the rod end cap from the connecting rod for an undetermined reason during the descent for landing. The ditch was a factor.NTSB MIA03LA055Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR72-212 · San Juan, PRThe aft passenger stair handrail collapsing due to undetermined reasons.