NTSB investigations, 2005
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 MIA05CA142Accident · No injuriesData collectionFinal reportCessna 172R · Daytona Beach, FLThe student pilot's improper flare and recovery from a bounced landing.NTSB LAX05LA254Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Tucson, AZThe pilot's inadvertent retraction of the landing gear during the landing rollout.NTSB LAX05LA253Accident · Serious injuriesLimited investigationFinal reportMalechek Q-200 · Delano, CAthe in-flight delamination and separation of a propeller blade for undetermined reasons.NTSB LAX05FA255Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · San Luis Obispo, CAThe pilot's continued flight into instrument meteorological conditions, and his failure to maintain clearance from the rising hilly terrain. Contributing factors were the pilot's inexperience regarding flying during the dark, nighttime condition, and the low…NTSB LAX05CA256Accident · No injuriesData collectionFinal reportLuscombe 8A · Benson, AZthe non-certificated pilot's failure to maintain directional control during the landing roll.NTSB DFW05CA203Accident · No injuriesData collectionFinal reportCessna 172M · El Dorado, ARThe student pilot's improper landing flare resulting in a hard landing and his improper recovery procedures for a bounced landing.NTSB DFW05CA199Accident · No injuriesData collectionFinal reportMrazek Rans S-14 · Forth Worth, TXThe loss of engine power for undetermined reasons. A factor contributing to the accident was the lack of suitable terrain for the forced landing.NTSB DCA05RA088Accident · No injuriesForeign investigationAirbus Industrie A-340 · Toronto, CanadaNTSB CHI05CA209Accident · No injuriesData collectionFinal reportNational Ballooning 751-12 · Indianola, IAThe in-flight fire due to the loose fuel line connection as a result of the pilot's inadequate preflight. A factor was the power lines.NTSB NYC05LA126Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Felton, DEThe mechanic's inadequate annual inspection, and failure to comply with an airworthiness directive, which resulted in a total failure of the second stage turbine rotor.NTSB LAX05WA259Accident · No injuriesForeign investigationPiper PA-31-350 · Pt. Augusta, AustraliaNTSB LAX05CA252Accident · No injuriesData collectionFinal reportBeech 35-A33 · Shelter Cove, CAthe pilot's failure to maintain adequate airspeed during an attempted go around, which resulted in a stall/mush and collision with the ground.NTSB DCA05RA086Incident · No injuriesForeign investigationBoeing 777-200 · Perth, AustraliaNTSB CHI05CA210Accident · No injuriesData collectionFinal reportBarr Barr Six · Knox, INThe undetermined cause of the fire during the taxi.NTSB CHI05CA208Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Willard, MOThe airplane overran the runway and hit a utility pole due to the pilot's delayed decision making and his failure to execute a go-around. Contributing factors included the exessive airspeed during the final approach, the high density altitude, the…NTSB ANC05CA115Accident · No injuriesData collectionFinal reportPiper PA-18 · Port Heiden, AKThe pilot's misjudged distance/altitude during final approach, which resulted in an undershoot and an in-flight collision with terrain.NTSB ANC05CA114Accident · No injuriesData collectionFinal reportCessna 170B · Fairbanks, AKThe pilot's inadequate compensation for the gusty wind conditions, which resulted is a loss of directional control during landing. A factor associated with the accident was the gusty wind condition.NTSB NYC05CA127Accident · No injuriesData collectionFinal reportYakovlev 55M · New Marlboro, MAThe pilot's improper weather evaluation which resulted in a precautionary off airport landing; and his improper flare which resulted in a hard landing. A factor in this accident was weather associated with thunderstorm activity.NTSB MIA05FA140Accident · 4 fatalField investigationFinal reportCessna 172S · Key West, FLThe failure of the pilot-in-command to maintain directional control of the airplane during the dark, night flight over water, resulting in the uncontrolled descent and in-flight collision with the water. A contributing factor in the accident was the pilot's…NTSB LAX05LA251Accident · No injuriesLimited investigationFinal reportCessna 210A · San Diego, CAThe pilot's failure to ensure that the landing gear was fully extended prior to landing. A contributing factor was the pilot's diverted attention.NTSB LAX05CA257Accident · Minor injuriesData collectionFinal reportCessna A150M · Trinity Center, CAthe pilot's failure to select an adequate altitude, which would assure clearance from the mountainous terrain while flying into a box canyon in high density altitude conditions.NTSB IAD05LA112Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Mount Holly, NJThe flight instructor's delayed remedial action. A factor was the flight instructor's failure to ensure that both pilots knew who was performing the maneuver.NTSB DFW05CA196Accident · No injuriesData collectionFinal reportCessna 120 · New Roads, LAThe pilot's failure to maintain control during the landing roll.NTSB CHI05CA207Accident · No injuriesData collectionFinal reportAllied Ag Cat Productions G-164A · Trufant, MIThe pilot's inadequate visual lookout and not maintaining clearance from the watering pivot during the aerial application maneuver and the unsuitable terrain he encountered during the emergency landing. A factor was the sunglare encountered.NTSB CHI05CA206Accident · No injuriesData collectionFinal reportLuscombe 8F · Sturtevant, WIThe pilot not obtaining/maintaining airplane control during the aborted takeoff. A factor was the berm.NTSB ANC05CA113Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Wasilla, AKThe pilot's selection of unsuitable terrain for taxi, which resulted in the airplane encountering a ditch, and the collapse of the main landing gear. A factor associated with the accident was the ditch.NTSB WAS05RA013Accident · 13 fatalForeign investigationMil Design Bureau Mi-172 · Zuria Mountains, UgandaNTSB SEA05WA160Accident · Serious injuriesForeign investigationBell 206L4 · Jeonnam, South KoreaNTSB SEA05CA156Accident · No injuriesData collectionFinal reportPiper PA-20-115 · Weiser, IDThe pilot's failure to maintain directional control during the landing roll, and his application of excessive braking as the aircraft started to depart the side of the runway.NTSB MIA05FA139Accident · 3 fatalField investigationFinal reportMooney M20C · Natchez, MSThe pilot's failure to maintain adequate airspeed during the initial climb after takeoff, which resulted in an inadvertent stall and subsequent uncontrolled descent to ground impact. A contributing factor was the pilot's lack of experience in complex…NTSB LAX05CA250Accident · No injuriesData collectionFinal reportAyres S2R-134 · Kerman, CAthe pilot's failure to obtain an adequate airspeed during an attempted takeoff.NTSB DFW05LA193Accident · 1 fatalLimited investigationFinal reportZivko Aeronautics Edge 540-T · Denison, TXThe pilot's failure to maintain control of the airplane while performing aerobatics. A contributing factor was the low altitude.NTSB DFW05CA195Accident · No injuriesData collectionFinal reportRobinson R22 Beta II · New Braunfels, TXThe student pilot's failure to maintain control of the helicopter and delayed remedial action by the flight instructor.NTSB DEN05LA117Accident · 1 fatalLimited investigationFinal reportBellanca 14-19-3 · Grand Junction, COA loss of engine power due to fuel starvation as a result of the improper fuel selector position. Factors contributing to the accident were the inadvertent stall, the ravine, and the steep drop off embankment.NTSB ANC05FA116Accident · 2 fatalField investigationFinal reportCessna 180 · Fairbanks, AKThe pilot's failure to maintain sufficient altitude/clearance from objects and terrain during cruise flight, which resulted in an in-flight collision with tree-covered terrain.NTSB NYC06WA085Incident · No injuriesForeign investigationSchweizer 269D · Jacobiparochie, NetherlandsNTSB LAX05LA248Accident · Minor injuriesLimited investigationFinal reportScandinavian Aero Industry KZ VII · Elko, NVThe pilot's failure to use carburetor heat, which resulted in the formation of carburetor ice and the total loss of engine power.NTSB LAX05LA247Accident · Minor injuriesLimited investigationFinal reportBeech B23 · Fallbrook, CAThe pilot's failure to maintain directional control during the landing rollout.NTSB DEN05CA116Accident · No injuriesData collectionFinal reportCessna 210E · Saratoga, WYthe pilot's failure to maintain aircraft control and the pilot's improper preflight planning/preparation. Contributing factors include the pilot's failure to maintain airspeed resulting in an inadvertent stall/mush, the pilot's failure to calculate a weight…NTSB CHI05CA204Accident · Minor injuriesData collectionFinal reportWilson Acrolite 1T · Oshkosh, WIThe partial loss of engine power due to an obstructed carburetor fuel metering jet. Factors to the accident included the low altitude at which the loss of engine power occurred, the contamination of the fuel system from degraded automobile-style fuel lines,…NTSB ATL05LA137Accident · 1 fatalLimited investigationFinal reportCessna T210 · Muscle Shoals, ALThe pilot's inadequate visual lookout, and failure to maintain clearance, which resulted in an in flight collision with a transmission wire.NTSB SEA05LA153Accident · No injuriesLimited investigationFinal reportMooney M20J · Sunriver, ORThe loss of engine power as a result of both sets of magneto points failing to open due to excessive wear of the nylon cam followers. The excessive wear of the cam followers was due to maintenance personnel's failure to follow the magneto manufacturer's…NTSB SEA05CA154Accident · Minor injuriesData collectionFinal reportGrumman American AA1B · Camas, WAThe student pilot's failure to maintain aircraft control during landing roll. A contributing factor was the gusty cross-wind weather condition.NTSB SEA05CA152Accident · No injuriesData collectionFinal reportCessna 180 · McCall, IDThe pilot's inadequate compensation for wind and his failure to maintain directional control. A factor was the crosswind.NTSB NYC05LA125Accident · No injuriesLimited investigationFinal reportCessna 172P · Caldwell, NJThe pilot's improper flare, which resulted in a hard landing. A factor was a partial loss of engine power, as reported by the pilot, for undetermined reasons.NTSB IAD05CA106Accident · No injuriesData collectionFinal reportGrumman American AA-5B · Stow, MAAn inadvertent collision with a deer during the landing roll. A factor was the night lighting conditions.NTSB DFW05CA194Accident · No injuriesData collectionFinal reportCessna 175A · Graham, OKThe impending loss of engine power as result of the failure of the generator mounting gasket resulting in engine oil starvation. A contributing factor was the lack of suitable terrain for the precautionary landing.NTSB CHI05CA255Accident · No injuriesData collectionFinal reportLet L 33 Solo · Stanton, MNThe pilot's failure to maintain a proper descent rate during landing due to the wind gusts. The wind gusts were a factor.NTSB CHI05CA205Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Holland, MIThe pilot's failure to maintain adequate airspeed which resulted in a stall, and subsequent collision with trees. Contributing to the accident were the trees.NTSB ANC05TA111Accident · No injuriesFinal reportMcDonnell Douglas 500D · Delta Junction, AKThe pilot's failure to maintain clearance from trees during the approach to landing, which resulted in the main rotor blades striking a tree. A factor associated with the accident was the tree.