NTSB investigations, 2005
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\") = 2005 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") = 2005 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 CHI06CA040Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Marshall, MOAn in-flight loss of engine power in descent due to fuel exhaustion, and the pilot's inaccurate preflight planning. Contributing to the accident was the unsuitable terrain the pilot encountered and the night conditions.NTSB SEA06LA021Accident · No injuriesLimited investigationFinal reportCessna 180 · Lopez, WAThe airline transport pilot, who was receiving recurrent training, failed to maintain aircraft control, which was followed by an inadvertent ground loop. A contributing factor was the inadequate supervision by the flight instructor.NTSB NYC06FA034Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Burlington, VTThe pilot's failure to follow the published instrument flight procedure, which resulted in an in-flight collision with terrain. Factors in the accident were the local air traffic controller's inadequate monitoring of the MSAW system, and his delayed…NTSB SEA06IA019Incident · No injuriesIncident investigationFinal reportGulfstream Aerospace G-5 · Hillsboro, ORThe failure of the right main landing gear (MLG) door uplock linkage actuator due to corrosion, which resulted in jamming of the right MLG during the initial takeoff climb.NTSB MIA06WA023Accident · 6 fatalForeign investigationBell B-206L · Cundinamarca, ColombiaNTSB MIA06FA022Accident · 1 fatalField investigationFinal reportAerospatiale AS350B · Homestead, FLThe failure of both pilot's to maintain visual lookout resulting in the mid-air collision. A factor in the accident was the failure of the AS-350B pilot to follow approach procedures suggested in the Speedway Heliport Operations Manual. Findings in the…NTSB LAX06LA044Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Tucson, AZthe separation of the mixture cable at the carburetor control arm, which resulted in a loss of power, and maintenance personnel's inadequate inspection of the airplane during the last annual inspection.NTSB DFW06CA032Accident · No injuriesData collectionFinal reportPiper PA-34-200 · Anahuac, TXThe student pilot's loss of directional control during the landing. A contributing factor was the flight instructor' delayed remedial action.NTSB DEN06FA018Accident · 1 fatalField investigationFinal reportAmerican Champion 8KCAB · Calhan, COthe pilot's failure to maintain aircraft control. Factors contributing to the accident were the low altitude, and the resultant stall/spin.NTSB NYC06LA033Accident · No injuriesLimited investigationFinal reportBoeing 737-800 · State College, PAThe pilot's improper touchdown and recovery from a bounced landing. Factors to the accident were the operator's failure to provide sufficient information on the use of autothrottles and bounced landing recovery techniques, along with the Federal Aviation…NTSB CHI06LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Batavia, OHThe loss of engine power due to fuel starvation and improper fuel management by the pilot while on approach. Contributing factors were the low altitude and unsuitable terrain encountered during an emergency landing.NTSB ANC06CA010Accident · No injuriesData collectionFinal reportCessna 180H · Anchorage, AKThe pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane encountering a snow berm, and nosing over. A factor associated with the accident was the snow berm.NTSB NYC06RA032Accident · 8 fatalForeign investigationCessna 208B · Moscow, RussiaNTSB LAX06LA041Accident · 2 fatalLimited investigationFinal reportTingle Special · Tucson, AZThe pilot's excessive use of power during takeoff, which resulted in an inadvertent torque roll shortly after lift off. Also causal was the pilot's failure to abort the takeoff when directional control could not be maintained during the takeoff roll.NTSB LAX06FA043Accident · 4 fatalField investigationFinal reportCessna T210N · Dana Point, CAThe pilot's inability to maintain aircraft control, which resulted in a loss of airspeed and a stall/spin. The inability of the pilot to maintain control of the airplane was likely due to an incapacitating cardiac event.NTSB LAX06CA042Accident · Minor injuriesData collectionFinal reportCessna A185E · Show Low, AZthe pilot's inadequate compensation for crosswind conditions and failure to maintain directional control, which resulted in a ground loop.NTSB MIA06CA021Accident · No injuriesData collectionFinal reportCessna 172R · Kissimmee, FLThe pilot's improper flare and remedial action during landing resulting in an in-flight loss of control and subsequent collision with terrain. A related factor was the crosswind.NTSB LAX06CA040Accident · No injuriesData collectionFinal reportCessna P210R · Palo Alto, CAthe pilot's misjudged altitude and distance, which resulted in an overrun, and his failure to execute a timely go-around during the approach.NTSB DFW06WA036Accident · 3 fatalForeign investigationBritten-Norman BN2A-21 · Cayo Province, BelizeNTSB DEN06GA017Accident · 1 fatalFinal reportCessna 182R · Alpine, WYthe pilot's intentional low level flight/maneuver. A contributing factor was his exercising poor judgment.NTSB CHI06TA033Accident · No injuriesFinal reportSchweizer 269C · Manhattan, KSThe binding of the main rotor blade's tachometer cable during cruise flight resulting in an observed split tachometer indication/aural alarm and perceived mechanical emergency and the unsuitable terrain the pilot encountered during the emergency landing. A…NTSB ATL06CA017Accident · No injuriesData collectionFinal reportCessna 120 · Woodstock, GAThe pilot's excessive braking resulted in a nose over during landing roll.NTSB LAX06CA038Accident · No injuriesData collectionFinal reportPiper PA-28RT-201 · Bakersfield, CAthe pilot's failure to maintain adequate airspeed, which resulted in an accelerated stall and hard landing.NTSB SEA06CA017Accident · No injuriesData collectionFinal reportCessna T210M · Salt Lake City, UTA loss of engine power due to fuel starvation as a result of the pilot's improper in-flight decision not to use the before landing checklist. A factor which contributed to the accident was the improper position of the mixture control.NTSB MIA06LA019Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-180 · Heathrow, FLA partial loss of engine power due to undetermined reasons resulting in a forced landing in a residential area.NTSB LAX06CA037Accident · Serious injuriesData collectionFinal reportHopkins Rutan VariViggen · Aguila, AZthe pilot's failure to maintain an adequate airspeed during landing approach, which resulted in an inadvertent stall. A contributing factor was the pilot's lack of experience in the accident airplane.NTSB DEN06LA014Accident · No injuriesLimited investigationFinal reportCessna 172L · Rock Springs, WYthe loss of engine power for reasons undetermined. Contributing to the accident was the dark night and lack of suitable terrain for a forced landing.NTSB CHI06FA032Accident · 1 fatalField investigationFinal reportAero Commander 500B · Gaylord, MIThe clearance not maintained with terrain during a nonprecision approach. Contributing factors were the ceiling, visibility, night conditions, and trees.NTSB ATL06CA016Accident · Minor injuriesData collectionFinal reportCessna 177 · New Bern, NCThe pilot's failure to activate the carburetor heat during approach resulting in a total loss of engine power due to carburetor ice.NTSB NYC06CA030Accident · Minor injuriesData collectionFinal reportCessna 208 · Southampton, NYThe flight instructor's improper flare and his inadequate remedial action, which resulted in a hard landing.NTSB LAX06LA036Accident · Serious injuriesLimited investigationFinal reportRyan Aeronautical ST3KR · Lincoln, CAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall while maneuvering.NTSB CHI06LA036Accident · No injuriesLimited investigationFinal reportCessna T310R · Fergus Falls, MNThe presence of wing ice during landing. Contributing factors were the icing conditions and flight into known adverse weather by the pilot.NTSB MIA06WA018Accident · 6 fatalForeign investigationCessna U206E · Ituango, ColombiaNTSB ATL06CA015Accident · Minor injuriesData collectionFinal reportPiper PA-32-260 · Bryson City, NCThe loss of engine power due to carburetor icing, and the pilot's failure to use carburetor heat.NTSB LAX06LA034Accident · No injuriesLimited investigationFinal reportBeech H35 · Kingman, AZa touchdown with the gear partially extended. A factor in the accident was an inoperative landing gear warning horn.NTSB LAX06LA032Accident · No injuriesLimited investigationFinal reportCessna 172R · Ramona, CAthe student pilot's failure to maintain directional control during the landing.NTSB LAX06CA033Accident · No injuriesData collectionFinal reportRotorway 162F · Chandler, AZa loss of engine power due to fuel contamination (rust, water) as a result of the pilot's inadequate preflight planning preparation.NTSB DFW06CA029Accident · No injuriesData collectionFinal reportAeronca 7DC · Saginaw, TXThe flight instructor's delayed remedial action. Contributing factors were the gusty winds.NTSB CHI06LA031Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Milwaukee, WIThe loss of engine power due to fuel starvation as a result of the pilot's fuel mismanagement. Factors to the accident included the pilot's impairment due to alcohol, the FAA's inadequate oversight when it issued the pilot a second class medical certificate,…NTSB NYC06CA031Accident · No injuriesData collectionFinal reportBeech F33A · Montgomery, NYThe pilot's misjudgment of the landing flare, which resulted in a hard landing short of the runway. Factors included the night lighting conditions, the time-out and reestablishment of the high intensity runway lighting, and the pilot's failure to go around.NTSB MIA06CA025Accident · No injuriesData collectionFinal reportPiper PA-12 · St. Petersburg, FLThe pilot's failure to maintain directional control during the landing roll resulting in substantial damage during a ground loop.NTSB LAX06CA035Accident · No injuriesData collectionFinal reportVans RV-4 · Apple Valley, CAa partial loss of engine power for undetermined reasons.NTSB DEN06LA015Accident · No injuriesLimited investigationFinal reportCessna 182 · Broomfield, COthe nose wheel assembly separation for reasons undetermined.NTSB DFW06LA028Accident · 1 fatalLimited investigationFinal reportRehler Gyrocopter · New Braunfels, TXThe pilot's failure to maintain control while landing. A contributing factor was the high winds.NTSB ATL06LA014Accident · 1 fatalLimited investigationFinal reportMooney M20M · Summerville, SCThe pilot's failure to follow the pre-landing checklist which resulted in a gear up landing and subsequent propeller strike. The pilots improper decision to attempt a go-around after the propeller strike, resulted in a loss of engine power and subsequent…NTSB LAX06LA030Accident · Serious injuriesLimited investigationFinal reportBell 47D1 · Rancho Murieta, CAa separation of the tail rotor assembly due to the reverse bending fatigue fracture of a tail rotor pitch change link bolt, resulting in a loss of control of the helicopter, and a hard landing during the uncontrolled descent.NTSB LAX06FA031Accident · 1 fatalField investigationFinal reportBeech F33A · Geyserville, CAthe pilot's failure to maintain an adequate terrain clearance altitude profile during the descent that resulted in controlled flight into terrain.NTSB DFW06CA031Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Osceola, ARThe pilot's failure to maintain control of the airplane while on final approach. A contributing factor was the gusty winds.NTSB CHI06FA030Accident · 1 fatalField investigationFinal reportPiper PA-23-160 · Bloomington, ILThe aircraft control not possible by the pilot during a visual approach to the runway due to the physical impairment of the pilot.NTSB OPS06IA001Incident · No injuriesIncident investigationFinal reportBoeing 737-400 · Fort Lauderdale, FLthe local controller's failure to monitor the operation and recognize a developing traffic conflict which resulted in a loss of separation between USA1251 and ComAir 5026. Contributing to the accident was the controller's incorrect prioritization of his…