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 SEA03FA110Accident · 1 fatalField investigationFinal reportHarshbarger W/Reed RV-8 · Grants Pass, ORCorrosion and contamination within the fuel servo unit and the pilot's delayed turn back to the runway. Contributing factors were trees and the pilot's impairment due to prescription medication.NTSB SEA03CA112Accident · No injuriesData collectionFinal reportCessna 177 · Woodland, WAThe pilot's premature liftoff and his failure to maintain/obtain airspeed and directional control during takeoff.NTSB NYC03LA133Accident · Serious injuriesLimited investigationFinal reportMBB BO-105C · Buffalo, NYThe pilot's improper interpretation of a descent as a power loss and subsequent decision to autorotate, which resulted in a hard landing. A factor in the accident was the collective friction.NTSB LAX03WA222Accident · 2 fatalForeign investigationRobinson R-22M · Camden, AustraliaNTSB CHI03LA172Accident · Minor injuriesLimited investigationFinal reportBell 206B · Baxter, MNThe pilot's failure to maintain control of the helicopter due to a loss of tail rotor effectiveness. Factors contributing to this accident were the helicopter's low airspeed, low altitude, the crosswind, and the trees.NTSB CHI03LA170Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Covert, MIFailure of the pilot to verify fuel quantity prior to the accident flight, and fuel exhaustion resulting in a loss of engine power. Contributing factors were the soft, rough, unsuitable terrain for a forced landing.NTSB SEA03WA114Accident · 2 fatalForeign investigationPiper PA-12 · Nimpo Lake, BC, CanadaNTSB NYC03FA132Accident · 1 fatalField investigationFinal reportAviat A-1 · Tyringham, MAThe pilot's incapacitation due to a heart attack, which resulted in a loss of aircraft control.NTSB LAX03LA210Accident · No injuriesLimited investigationFinal reportBeech S35 · Weed, CAthe pilot's failure to maintain an adequate terrain/object clearance altitude.NTSB LAX03FA206Accident · 1 fatalField investigationFinal reportSchleicher ASW-27B · Valyermo, CAThe pilot's failure to maintain adequate terrain clearance altitude and his delayed remedial action by not turning away from the ridge when a lack of lift became apparent..NTSB DEN03LA108Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-180 · Green River, UTpilot's improper preflight planning and failure to maintain obstacle clearance. Contributing factors include improper short field takeoff procedures and the high vegetation at the end of the runway.NTSB CHI03LA176Accident · No injuriesLimited investigationFinal reportAllied Ag Cat Productions G-164B · Dyess, ARThe loose fittings on the bleed air system which resulted in a loss of engine power, and the unsuitable terrain encountered during the forced landing. Factors to the accident were the watery and the muddy conditions and the inadequate fastening of the bleed…NTSB CHI03LA171Accident · Serious injuriesLimited investigationFinal reportAyres S2R-T34 · Marked Tree, ARThe pilot's failure to maintain clearance with the wire. Contributing factors were the low altitude flight/maneuver and the static wire.NTSB CHI03LA169Accident · Minor injuriesLimited investigationFinal reportCessna 182L · Atchison, KSThe pilot's inadequate inflight decision, which resulted in a landing with a tailwind and an overrun of the runway. Factors contributing to the accident were the tailwind encountered on landing rollout, the variable, gusty winds encountered while in the…NTSB ATL03FA114Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Scottsboro, ALThe pilot's improper fuel management which resulted in a loss of engine power due to fuel starvation and subsequent impact with trees.NTSB MIA03LA127Accident · Serious injuriesLimited investigationFinal reportEmbraer EMB-145LR · Taylor, FLThe in-flight encounter with turbulence during normal descent resulting in a serious injury to a passenger. A finding in the investigation was the seatbelt sign had been on for approximately 2 minutes at the time of the turbulence encounter.NTSB MIA03CA125Accident · No injuriesData collectionFinal reportCessna 172S · Melbourne, FLThe pilot's improper flare and inadequate recovery from a bounced landing. Contributing factors were the pilot's failure to maintain directional control and his failure to execute a go-around.NTSB LAX03WA205Accident · No injuriesForeign investigationCessna T210L · Anahim Lake, CanadaNTSB CHI03LA167Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Atwood, ILThe pilot's selection of an unsuitable landing area and his improper decision to continue the approach without the airport and runway clearly in-sight. Factors contributing to the accident were the pilot's disorientation, the transmission wires, and the road…NTSB ATL03LA108Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Fort Mill, SCThe pilot's mismanagement of the fuel supply, which resulted in fuel starvation and the subsequent loss of engine power.NTSB SEA03LA113Accident · No injuriesLimited investigationFinal reportCessna 206 · Soldier Bar, IDThe overload failure of the nose landing gear assembly during the landing roll, due to an improper maintenance installation. A factor was the rough/uneven terrain condition.NTSB SEA03LA108Accident · No injuriesLimited investigationFinal reportMcCarty Avid Magnum · Renton, WAThe flight instructor's unexpected encounter with control interference when the student applied brakes during the landing roll.NTSB SEA03FA106Accident · 1 fatalField investigationFinal reportDowner RC-3 · Yelm, WAThe failure of the pilot to abort the takeoff roll. Factors contributing to the accident included the failure of the aircraft to accelerate for undetermined reasons and the trees.NTSB MIA03WA126Accident · No injuriesForeign investigationCessna 402B · LittleWhale Cay, BahamasNTSB MIA03FA124Accident · 5 fatalField investigationFinal reportCessna 172N · Deerfield Beach, FL**This case was revised 6/10/2005 and 2/24/2016. Refer to the public docket for this accident for details.** The failure of the pilot of N4903F, the Cessna 172, and the pilot of N759XA, the Cessna 182, to see and avoid each other while operating in Class E…NTSB LAX03LA202Accident · Minor injuriesLimited investigationFinal reportBellanca 8GCBC · Williams, CAthe loss of engine power on takeoff for undetermined reasons.NTSB DCA03WA040Accident · Minor injuriesForeign investigationEelde, NetherlandsNTSB CHI03LA168Accident · No injuriesLimited investigationFinal reportCessna A188B · Hornersville, MOThe pilot's failure to maintain directional control of the airplane during takeoff. A contributing factor was the crosswind.NTSB NYC03LA160Accident · No injuriesLimited investigationFinal reportMooney M20E · Guilford, OHThe pilot's misjudged speed and distance while landing, and his failure to do a go-around.NTSB MIA03LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Ocean Springs, MSA loss of engine power due to starvation as a result of the pilot's continued operation of an airplane with known deficiencies.NTSB MIA03CA129Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Kissimmee, FLThe inadequate supervision by flight instructor for his failure to prevent incorrect anti-torque pedal input by the student resulting in the helicopter yawing at touchdown. A factor in the accident was the incorrect anti-torque pedal input by the student…NTSB IAD03FA058Accident · 2 fatalField investigationFinal reportPiper PA-30 · NewPhiladelphia, OHThe pilot's mismanagement of the fuel, and his failure to maintain minimum controllable airspeed with one engine inoperative.NTSB FTW03LA181Accident · Minor injuriesLimited investigationFinal reportPiper PA-36-300 · Gruver, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN03LA106Accident · No injuriesLimited investigationFinal reportCessna 180 · Ogden, UTthe pilot's inadequate compensation for wind conditions and his failure to maintain directional control.NTSB ATL03LA119Accident · No injuriesLimited investigationFinal reportCessna 182J · Southern Pines, NCThe pilot's improper landing flare which resulted in a hard landing.NTSB ATL03LA106Accident · No injuriesLimited investigationFinal reportPolstra Zodiac CH 601 HDS · Thomson, GAThe total loss of engine power due to the fatigue fracture of the No. 3 cylinder intake valve, which resulted in a forced landing to rough terrain and subsequent collision with small trees and a tree stump.NTSB ATL03FA107Accident · 2 fatalField investigationFinal reportPiper PA-31P · Augusta, GAThe pilot's failure to maintain airspeed while maneuvering on initial take off climb resulting in an inadvertent stall, loss of control, and subsequent in-flight collision with trees and a swamp. A factor in the accident was a reported loss of engine power…NTSB SEA03LA105Accident · No injuriesLimited investigationFinal reportCessna T337G · Lewistown, MTInadequate preflight planning/preparation prior to takeoff, and the pilot's failure to maintain aircraft control during the takeoff. An inadvertent stall and rough terrain were factors.NTSB SEA03LA103Accident · No injuriesLimited investigationFinal reportCessna 172P · Seattle, WAThe dual student's failure to maintain aircraft control and the flight instructor's delayed remedial action. Contributing factors were the crosswind condition and the flight instructor's lack of experience.NTSB NYC03FA131Accident · 4 fatalField investigationFinal reportCessna 205 · Jeannette, PAThe loss of power caused by fragments of the air filter being ingested in the engine. A factor was the pilot's delayed decision to perform a forced landing after experiencing a partial loss of engine power.NTSB LAX03FA200Accident · 4 fatalField investigationFinal reportMcDonnell Douglas 369D · Volcano, HIa loss of engine power due to the fatigue fracture and separation of the compressor coupling adapter. The fatigue fracture was initiated by fretting on the pilot diameter due to both the inadequate design of the coupling and the coaxial misalignment of the…NTSB LAX03CA201Accident · Minor injuriesData collectionFinal reportSchleicher ASW-20 · Idyllwild, CAThe combined effects of a loss of thermal lift and a gust induced loss of airspeed at a low above ground altitude, which resulted in a descent to impact with trees. The pilot's failure to maintain an adequate terrain clearance margin while cruising in…NTSB DEN03LA105Accident · Serious injuriesLimited investigationFinal reportAdams Balloon A55 · Albuquerque, NMthe pilot's improper planned approach for a landing and obstacle clearance not maintained. A contributing factor was the power lines.NTSB CHI03LA183Accident · Serious injuriesLimited investigationFinal reportEnstrom 280C · West Branch, MIThe loss of engine power due to the fatigue failure of the connecting rod cap. A related factor was the unsuitable terrain the pilot encountered.NTSB CHI03LA161Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Gridley, ILThe checklist not followed by the pilot and the fuel starvation of the engine. The incorrect fuel tank selector position by the pilot,, and the lack of recurrent training were contributing factors.NTSB SEA03LA104Accident · No injuriesLimited investigationFinal reportMooney M20C · Boise, IDFailure of the welds on the nose landing gear retraction truss during taxi for takeoff..NTSB SEA03CA102Accident · No injuriesData collectionFinal reportPiper PA-18 · Silver City, MTProper descent rate not maintained while on final approach. A wind gust is a factor in the accident.NTSB MIA03LA123Accident · Minor injuriesLimited investigationFinal reportZenith 601HDS · Immokalee, FLExcessive rotor distributor shaft clearance that resulted in damage to the distributor rotor, a loss of ignition, the engine ceasing to operate. This resulted in a forced landing to unsuitable terrain and the airplane nosing over.NTSB MIA03CA128Accident · Minor injuriesData collectionFinal reportKolb Mkiii · Bunnell, FLThe inadequate preflight inspection of the airplane by the pilot-in-command (pilot) for his failure to assure that the forward attachment of the right horizontal stabilizer was secured and safetied before flight resulting in rotation of the leading edge of…NTSB LAX03LA198Accident · No injuriesLimited investigationFinal reportKowtun Mini 500 · Phoenix, AZThe pilot's failure to maintain directional control of the helicopter.