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 MIA05CA054Accident · No injuriesData collectionFinal reportCessna 182S · Punta Gorda, FLThe pilot's improper flare resulting in a hard landing and subsequent damage to the firewall.NTSB DFW05CA076Accident · No injuriesData collectionFinal reportCessna 172 · Marshall, TXThe pilot's improper engine starting procedure resulting in a loss of control.NTSB DFW05CA061Accident · Minor injuriesData collectionFinal reportMaule M-4-210C · McAlister, OKThe loss of engine power due to fuel exhaustion as result of the pilot's improper fuel calculations, and his inadequate in-flight planning decision. A contributing factor was the pilot's failure to complete an emergency pre-landing checklist, which resulted…NTSB DCA05WA028Incident · No injuriesForeign investigationBoeing B-747-200 · Dusseldorf, GermanyNTSB LAX05LA075Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Llano, CAthe pilot's inadequate preflight planning and failure to verify the amount of fuel onboard the airplane prior to departure, which resulted in loss of engine power due to fuel exhaustion.NTSB DFW05WA064Accident · 2 fatalForeign investigationBell 206L3 · Villarrica, ChileNTSB LAX05LA074Accident · No injuriesLimited investigationFinal reportMdhi 369E · Pahoa, HIthe in-flight separation of the tail rotor blade abrasion strip due to a degraded adhesive bond and fatigue fracture of the metallic abrasion strip. The ultimate cause for the degraded bond is unknown.NTSB DFW05FA059Accident · 2 fatalField investigationFinal reportBeech BE-36 · Brownwood, TXThe pilots failure to maintain proper altitude and clearance while on final approach to land. Contributing factors were the pilot's lack of familiarity with the geographic area, the dark night light conditions, the non-availability of a visual approach glide…NTSB ANC05CA024Accident · No injuriesData collectionFinal reportPiper PA-19 · Big Lake, AKThe pilot's selection of an unsuitable takeoff/landing/taxi area, which resulted in an on-ground encounter with a berm, a loss of control on the ground, and collapse of the main landing gear. Factors associated with the accident were flat light conditions,…NTSB SEA05LA039Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Lewiston, IDThe pilot's failure to maintain directional control during the landing roll. Wind gusts and the pilot's inadequate compensation for wind conditions were factors.NTSB SEA05FA038Accident · 3 fatalField investigationFinal reportCirrus SR22 · Hood River, ORThe pilot's failure to maintain terrain clearance. Contributing factors were the mountainous terrain, the low ceiling weather conditions, and dark night light conditions.NTSB MIA05CA053Accident · No injuriesData collectionFinal reportLee Harold Swarthout Velocity Xlrg · Daytona Beach, FLThe failure of the pilot-in-command to maintain directional control of the airplane during the landing roll resulting in the on-ground collision with a fence and a ditch.NTSB DFW05FA058Accident · 2 fatalField investigationFinal reportBeech J-35 · Abernathy, TXThe pilot's improper positioning of the fuel tank selector, which resulted in fuel starvation and a subsequent loss of engine power while maneuvering.NTSB DFW05CA077Accident · No injuriesData collectionFinal reportCessna 182 · Graham, TXThe airplane's collision with a deer during a go-around. A contributing factor was the prevailing night condition.NTSB DFW05CA060Accident · No injuriesData collectionFinal reportSabreliner 40 · San Antonio, TXThe failure of the aircraft hydraulic system as result of improper maintenance by company maintenance personnel.NTSB DCA05WA027Accident · Minor injuriesForeign investigationCessna 208B · Colquiri, BoliviaNTSB CHI05FA056Accident · 5 fatalField investigationFinal reportCessna 421C Riley Turbine E · Overland Park, KSThe pilot's failure to maintain adequate altitude/clearance during cruise flight, resulting in collision with trees. Contributing factors were the low altitude and low ceiling.NTSB DFW05RA063Accident · 2 fatalForeign investigationPiper PA-32RT-300 · Guerrero, MexicoNTSB DFW05LA067Accident · No injuriesLimited investigationFinal reportCessna 172F · Sallisaw, OKA loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN05CA050Accident · No injuriesData collectionFinal reportGrumman G-1159 · Logan, UTthe pilot's improper IFR operation by which he failed to comply to the missed approach procedure, and his improper evaluation of the weather resulting in an encounter with fog and his loss of visual contact with the runway during the landing.NTSB LAX05LA073Accident · 1 fatalLimited investigationFinal reportCessna 172SP · Casa Grande, AZthe pilot's inadvertent encounter with a rotating propeller. Contributing factors were the dark night conditions and the pilot's fatigued condition.NTSB IAD05LA034Accident · No injuriesLimited investigationFinal reportCessna 414 · Akron, OHThe pilot's failure to obtain a complete weather briefing, which resulted in an inadequate weather decision, and flight into known icing conditions. A factor was the airplane not being equipped for flight in icing conditions.NTSB DFW05LA066Accident · No injuriesLimited investigationFinal reportBell 206B · Pinehurst, TXThe flight instructor's delay in taking remedial action, which resulted in a hard landing.NTSB DFW05CA057Accident · No injuriesData collectionFinal reportCessna 182J · Malvern, ARThe pilot's failure to maintain directional control during the landing roll. A contributing factor was the sun glare.NTSB DCA05WA032Incident · No injuriesForeign investigationBoeing B-767-332 · Nice, FranceNTSB CHI05CA057Accident · No injuriesData collectionFinal reportCessna 421C · Muncie, INThe inadequate flare and the directional control not maintained/obtained by the pilot. Contributing factors were the instrument meteorological conditions, the icing conditions, the limited visibility afforded by the windshield antiice/deice system, and the…NTSB ANC05TA022Accident · No injuriesFinal reportCessna 185 · Eek, AKThe pilot's inadequate evaluation of weather conditions, which resulted in an on ground encounter with terrain during the landing roll. Factors associated with the accident were a tailwind, and snow-covered, icy terrain conditions.NTSB WAS05WA004Accident · 5 fatalForeign investigationAerostar 600 · Cornelia, South AfricaNTSB SEA05FA037Accident · 2 fatalField investigationFinal reportAero Commander AC200D (Meyers) · Hatch, UTThe pilot's failure to maintain aircraft control while maneuvering. Inadequate airspeed, the pilot's diverted attention, and low altitude flight were factors.NTSB MIA05CA051Accident · No injuriesData collectionFinal reportRobinson R22 · Gulf Port, MSThe student pilot's inadequate flare and his failure to maintain rotor rpm which resulted in a hard landing. Also causal was the instructor's inadequate supervision of the flight.NTSB DFW05TA056Accident · Minor injuriesFinal reportSchweizer 269D · San Antonio, TXThe inadequate supervision and delayed remedial action by the flight instructor, which resulted in an inadvertent dynamic rollover.NTSB CHI05FA055Accident · 1 fatalField investigationFinal reportCessna T-37B · Hollister, OKThe pilots of the AT-502B and the T-37B failed to maintain adequate visual lookout and did not maintain clearance from the other aircraft. Contributing factors included the lack of a transponder and radios on the AT-502B, and the reduced visibility due to…NTSB WAS05WA008Accident · No injuriesForeign investigationRotorway Exec 162 · Georgetown, GuyanaNTSB NYC05LA043Accident · No injuriesLimited investigationFinal reportBoeing 737-247 · Covington, KYThe catering truck driver's failure to maintain clearance of the parked airplane by his inadvertent depressing the accelerator. A factor in this accident was the catering truck driver's diverted attention.NTSB IAD05LA033Accident · No injuriesLimited investigationFinal reportGhiles MCR-01 VLA · Cincinnati, OHA total loss of engine power due to an oil hose collapse, which resulted in failure of the #4 connecting rod.NTSB ATL05LA047Accident · No injuriesLimited investigationFinal reportBeech C-23 · Roseboro, NCThe overload fracture of the engine oil cooler for undetermined reasons.NTSB ATL05CA045Accident · Minor injuriesData collectionFinal reportCessna 152 · Nashville, TNA loss of engine power due to fuel starvation as a result of fuel system blockage.NTSB MIA05LA052Accident · No injuriesLimited investigationFinal reportPaul Pajak RV-6A · Sanford, FLThe pilots failure to use carburetor heat in conditions conducive to carburetor icing which resulted in loss of engine power and collision with trees and ground during the resultant forced landing.NTSB LAX05LA070Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Pauma Valley, CAthe loss of engine power due to an undetermined obstruction in the vent system for the fuel tanks and failure of the fuel caps to vent.NTSB LAX05CA071Accident · No injuriesData collectionFinal reportRobinson R22B · Rialto, CAthe student pilot's improper use of the cyclic control during a practice autorotation, and the inadequate supervision by the certified flight instructor.NTSB LAX05LA069Accident · 1 fatalLimited investigationFinal reportSlipStream Revelation · Camarillo, CAthe pilot's failure to maintain an adequate airspeed during a go-around, which resulted in a stall/spin.NTSB LAX05LA068Accident · No injuriesLimited investigationFinal reportCessna T210L · Yuba City, CAthe pilot's inadequate preflight preparation and failure to verify the fuel supply, which resulted in fuel exhaustion and subsequent loss of engine power.NTSB IAD05FA032Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Coconut Creek, FLThe pilot's failure to maintain aircraft control, which resulted in an uncontrolled descent to the ground. Factors included an avionics failure, pilot disorientation, and instrument meteorological conditions. A factor in the severity of the impact was the…NTSB SEA05LA036Accident · No injuriesLimited investigationFinal reportCessna U206F · Prevost, WAThe pilot not identifying unsafe landing conditions, and his subsequent intentional swerve during the landing roll resulting in impacting a ditch. Contributing factors were the ice/frost on the grass/dirt one-way runway (1,560 feet in length), the unexpected…NTSB NYC05FA042Accident · 1 fatalField investigationFinal reportEmbraer EMB-110P1 · Swanzey, NHThe pilot's improper decision to attempt a single-engine missed approach with the airplane in a slow airspeed, full flap configuration, which resulted in a minimum control speed (Vmc) roll. Contributing factors included an inoperative engine for undetermined…NTSB MIA05FA050Accident · 2 fatalField investigationFinal reportCessna T337G · Lakeland, FLThe pilot's operation of the airplane with known deficiencies in equipment related to pitch, an abrupt pitch-up during the initial climb after takeoff for undetermined reasons and the failure of the pilot to maintain airspeed (Vs) resulting in inadvertent…NTSB LAX05LA065Accident · No injuriesLimited investigationFinal reportCessna T210M · Mesa, AZthe pilot's failure to use the emergency gear extension procedure to manually extend the landing gear to the down and locked position.NTSB DFW05LA069Accident · 1 fatalLimited investigationFinal reportNolen Lite Squared · Holdenville, OKUndeterminedNTSB DFW05FA055Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Patterson, LAThe pilot's failure to follow check-list procedures and the required placard instructions, which resulted in the fuel selectors being selected to the improper fuel tanks for take-off, resulting in a loss of engine power to the left engine. Also causal was the…NTSB CHI05CA054Accident · No injuriesData collectionFinal reportCessna 152 · Stockton, MOthe pilot's failure to attain the proper touchdown point, which resulted in an overrun. Contributing factors were the tailwind and dusk light conditions.