NTSB investigations, 2005
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\") = 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 CHI05CA119Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Beloit, WIThe pilot's misjudgment of distance/altitude which resulted in an undershoot of the runway and collision with trees.NTSB ATL05LA084Accident · Minor injuriesLimited investigationFinal reportde Havilland DH-82-C · Franklin, GAThe total failure of the left magneto resulting in a partial loss of engine power on initial takeoff climb, forced landing, and in-flight collision with wires and the ground.NTSB MIA05CA109Accident · No injuriesData collectionFinal reportCessna 172R · Daytona Beach, FLThe student pilot's improper landing flare and the CFI's inadequate supervision resulting in a hard landing and damage to the airplane.NTSB LAX05FA184Accident · 2 fatalField investigationFinal reportBellanca 14-13-3 · Caliente, CAThe pilot's inadvertent encounter with instrument meteorological conditions and failure to maintain adequate terrain clearance, which resulted in controlled flight into the terrain. Contributing factors were the pilots' delayed decision to reverse course, the…NTSB LAX05CA182Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Oxnard, CAthe pilot's failure to maintain an adequate clearance from the building. The pilot's diverted attention was a factor.NTSB DCA05WA067Accident · No injuriesForeign investigationBoeing B-777-232 · London, United KingdomNTSB CHI05CA120Accident · No injuriesData collectionFinal reportBrantly Helicopter B-2B · Lakeview, MIThe dual student failed to maintain adequate rotor rpm during the practice autorotation and the instructor's delay in attempting remedial action. A factor associated with the accident was the soft terrain that was encountered.NTSB DFW05LA126Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-602 · Ralls, TXThe pilot's failure to maintain clearance from the antenna tower. Contributing factors were the recency of the tower's construction and the lack of obstruction lights on the tower.NTSB DFW05LA125Accident · 2 fatalLimited investigationFinal reportAerostar International S53A · Shreveport, LAThe pilot's failure to maintain clearance from electrical power lines.NTSB DEN05LA081Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · St. George, UTthe pilot's improper autorotation. A contributing factor was the flight instructor's inadequate supervision of the pilot.NTSB DEN05CA079Accident · No injuriesData collectionFinal reportSchweizer 269C · Pueblo, COthe student pilot's failure to maintain control of the helicopter during the landing. Contributing to the accident was the flight instructor's inadequate supervision of the student pilot.NTSB DEN05CA078Accident · No injuriesData collectionFinal reportBell 47G-5A · Brush, COThe pilot's failure to maintain clearance from the truck trailer during takeoff. A factor contributing to this accident was the truck trailer.NTSB CHI05IA116Incident · No injuriesIncident investigationFinal reportEmbraer EMB-145LR · Kansas City, MOThe fatigue failure during cruise flight of the fan spinner and forward fan retaining ring due to an interference between the mating parts resulting from the inadequate design by the manufacturer.NTSB CHI05CA147Accident · Minor injuriesData collectionFinal reportBell 47G · Twin Brooks, SDThe pilot's inadequate lookout and his failure to maintain clearance with the power lines. A factor was the low altitude at which the helicopter was operating.NTSB CHI05CA118Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Ypsilanti, MIThe pilot's inability to maintain directional control of the airplane due to undetermined reasons. Factors associated with the accident were the crosswind condition and the taxiway sign which was contacted. This case was modified October 12, 2006!!NTSB CHI05CA117Accident · Serious injuriesData collectionFinal reportAviat A-1B · Lodgepole, SDThe poor inflight planning and the pilot's inability to maintain control of the airplane. A factor associated with the accident was the low altitude at which the airplane encoutnered its own wake.NTSB LAX05LA180Accident · No injuriesLimited investigationFinal reportCessna 172M · Tucson, AZThe student pilot's improper flare that induced a porpoise, which resulted in the overload failure of the nose wheel assembly.NTSB IAD05IA066Incident · No injuriesIncident investigationFinal reportCessna R182 · West Mifflin, PAThe failure of the landing gear actuator downlock pin due to fatigue, which resulted in the nose landing gear collapsing on landing.NTSB DFW05LA123Accident · Serious injuriesLimited investigationFinal reportBell 206B · Huffman, TXThe pilot's inadequate preflight and his failure to disconnect the external load cable prior to takeoff.NTSB DFW05CA127Accident · Serious injuriesData collectionFinal reportRobinson R22 Beta · Rock Springs, TXThe pilot's failure to maintain clearance with a static line. A contributing factor was the low altitude.NTSB SEA05WA111Accident · 2 fatalForeign investigationBeech B55 · Ipil, PhilippinesNTSB NYC05LA123Accident · No injuriesLimited investigationFinal reportCessna 172P · Islip, NYThe pilot's failure to maintain clearance from a parked vehicle while taxiing.NTSB LAX05CA177Accident · No injuriesData collectionFinal reportPiper PA-34-220T · Scottsdale, AZthe student pilot's inadvertent retraction of the landing gear, and the flight instructor's inadequate supervision of the flight.NTSB DFW05CA122Accident · No injuriesData collectionFinal reportBeech BE-55 · Midland, TXThe pilot's failure to extend the landing gear which resulted in a gear-up landing. A contributing factor was the pilot's failure to follow the checklist.NTSB DEN05IA076Incident · No injuriesIncident investigationFinal reportBoeing 737-322 · Denver, COthe improper use of procedure used by the ground personnel resulting in the right wing of the aircraft colliding with the left wing of another aircraft. A factor in this incident was the failure to maintain clearance by the flight crew of the other aircraft.NTSB ATL05CA083Accident · Minor injuriesData collectionFinal reportRand Robinson Engineering KR-2 · Vienna, GAA loss of engine power due to the owner/pilot mechanic's improper balancing of the modification to engine crankshaft which resulted in an overload failure.NTSB MIA05WA105Accident · 10 fatalForeign investigationBeech 65-A80 · Patagonia, ArgentinaNTSB LAX05LA176Accident · No injuriesLimited investigationFinal reportHughes 369D · Kihei, HIthe partial loss of engine power due to fuel contamination. The fuel contamination was due to the failure of the maintenance personnel to ensure that the helicopter's fuel system had been thoroughly cleaned after a known previous contamination event, and the…NTSB ENG05WA013Incident · No injuriesForeign investigationBoeing 717-200 · Hobart Tasmania, AustraliaNTSB ATL05LA081Accident · 1 fatalLimited investigationFinal reportPaul E. Conner Rotor-EZ · St Elmo, ALThe pilot's mismanagement of the fuel supply, which resulted in fuel starvation and the subsequent loss of engine power. The pilot failed to maintain airspeed resulting in an inadvertent stall.NTSB ATL05FA082Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Nashville, TNThe pilot's failure to maintain airspeed while maneuvering resulting in an in flight loss of control, stall, and collision with trees and the ground. A factor was the pilot's impairment due to drugs.NTSB ATL05CA080Accident · No injuriesData collectionFinal reportPiper J4E · Akron, ALThe pilot's premature liftoff and his failure to attain adequate airspeed which resulted in a stall/mush. Also causal was the pilot's delay in aborting the takeoff.NTSB NYC05LA085Accident · Minor injuriesLimited investigationFinal reportCessna 525A · Atlantic City, NJThe pilot's improper decision to plan a flight to a runway of insufficient length, his improper in-flight decision to land on that inadequate runway with a tailwind, and his failure to obtain the proper touchdown point. A factor in the accident was the…NTSB MIA05LA104Accident · Minor injuriesLimited investigationFinal reportBritish 167 StrikemasterMK83 · Boca Raton, FLThe delay by the pilot-in-command to abort the takeoff after recognizing excessive elevator control forces for undetermined reasons during the landing roll, resulting in the on-ground collision with a fence.NTSB LAX05WA174Accident · 2 fatalForeign investigationAmerican Champion 7GCAA · Stonefield, AustraliaNTSB LAX05FA175Accident · 2 fatalField investigationFinal reportCessna 182M · Palm Springs, CAThe pilot's inadequate in-flight planning/decision, and his failure to maintain clearance while maneuvering in rising terrain, resulting in an in-flight collision with terrain.NTSB LAX05CA181Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Tucson, AZthe improper flare by an undetermined crewmember, which resulted in a hard landing.NTSB DFW05CA124Accident · No injuriesData collectionFinal reportCessna 210L · Houston, TXThe pilot's failure to maintain directional control during landing roll. A contributing factor was reported partial loss of brake control.NTSB ANC05CA077Accident · No injuriesData collectionFinal reportPiper PA-18 · Dillingham, AKThe instructor pilot's inadequate supervision, and the dual student's failure to maintain directional control. Factors associated with the accident were a crosswind, and an inadvertent ground loop.NTSB SEA05LA106Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Puyallup, WAThe fatigue cracking of the upper torque link attach lugs on the right main landing gear strut, which resulted in separation of the right main landing gear.NTSB SEA05LA099Accident · No injuriesLimited investigationFinal reportHorvath Pitts S-1C · Creswell, ORLoss of engine power as a result of a carburetor float drop restriction during cruise flight. Tall grass in the landing area was a factor in the accident.NTSB SEA05LA098Accident · 1 fatalLimited investigationFinal reportCessna 150M · Elk River, IDThe pilot's inability to control the airplane during initial climb due to the restricted movement of the control yoke and rudder control by the passenger, which resulted in a loss of control and impact with trees.NTSB NYC05LA084Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Saluda, VAA loss of engine power due to an unsecured mixture control cable, which was not properly secured by maintenance personnel during a recent annual inspection. Also causal was the airplane owner's continued operation of the airplane with known deficiencies.NTSB LAX05LA173Accident · Minor injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Sonoma, CAa partial loss of engine power, which resulted from the fuel servo leaking and generating an excessively rich fuel/air mixture. A factor was the owner's failure to comply with a service bulletin.NTSB LAX05LA172Accident · Minor injuriesLimited investigationFinal reportRepublic RC-3 · Geyserville, CAA loss of engine power due to failure of the number 1 connecting rod bearing due to a probable oil starvation.NTSB LAX05LA171Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Jean, NVthe pilot's in-flight decision to continue a flight with weak thermal lift activity, and his delayed recognition of a loss of altitude while attempting to find a thermal in which to soar. A factor in the accident was the lack of suitable terrain for the…NTSB LAX05LA170Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-C1 · Glendale, AZthe pilot's misjudged landing flare that resulted in a stall and hard landing.NTSB LAX05LA168Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Seligman, AZthe pilot's fuel system mismanagement that led to a fuel starvation induced loss of power in the left engine. Also causal was the pilot's improper use of the emergency landing gear extension system.NTSB LAX05CA169Accident · No injuriesData collectionFinal reportBeech C23 Sundowner · San Martin, CAthe pilot's improper landing flare that resulted in a porpoise and a hard landing.NTSB IAD05LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Dover, DEThe separated baffle which blocked the tailpipe resulting in a subsequent total loss of engine power.