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 CHI05CA090Accident · No injuriesData collectionFinal reportCessna 172R · Kalamazoo, MIThe pilot's failure to maintain directional control and the excessive taxispeed.NTSB SEA05LA071Accident · Minor injuriesLimited investigationFinal reportPark Kitfox IV · Eagle Point, ORLoss of partial engine power during initial climb for undetermined reasons. Soft terrain was a factorNTSB NYC05LA067Accident · No injuriesLimited investigationFinal reportCessna 182S · West Mifflin, PAThe pilot's failure to maintain aircraft control during the takeoff. A factor in this accident was the gusty wind conditions.NTSB LAX05LA131Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 2-32 · Mokuleia, HIthe pilot's failure to maintain an adequate airspeed while maneuvering during a scenic flight, which led to an inadvertent stall/spin and secondary stall/spin encounter. Contributing factors were the pilot's lack of total flight experience, his inadequate…NTSB IAD05FA052Accident · 2 fatalField investigationFinal reportPiper PA-28R-201 · Green Creek, NJThe flight crew's failure to maintain terrain clearance while executing a practice published instrument approach in night visual meteorological conditions. A factor in the accident was the dark night.NTSB ANC05LA055Accident · No injuriesLimited investigationFinal reportBritten-Norman BN-2A Islander · Klawock, AKThe fracture of the aluminum alloy landing gear bracket assembly, which resulted in a loss of control during the landing roll.NTSB SEA05LA070Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Corvallis, ORThe student pilot's failure to maintain directional control while attempting to turn in the direction necessary to air-taxi to the landing pad, and the flight instructor's failure to take remedial action soon enough to correct the problems created when the…NTSB CHI05CA089Accident · Serious injuriesData collectionFinal reportFranz RV-6 · Howell, MIThe pilot's failure to maintain directional control during the landing rollout which resulted in the aircraft departing the runway pavement and nosing over. An additional cause was the pilot's inadequate compensation for the crosswind condition. Contributing…NTSB ATL05LA071Accident · No injuriesLimited investigationFinal reportCessna 152 · Jacksonville, NCThe loss of engine power due to the failure of the carburetor mixture cable which resulted in fuel starvation.NTSB SEA05CA069Accident · No injuriesData collectionFinal reportCessna A188B · Palouse, WAThe pilot's failure to maintain terrain clearance during the initial climb after takeoff. A tailwind, hilly terrain and inadequate airspeed were factors.NTSB MIA05LA086Accident · Serious injuriesLimited investigationFinal reportFrank D. Amador Searey · Green Cove Spr, FLThe airplane builder's improper installation of the left rudder control cable, which resulted in the cable becoming jammed, a loss of directional control during takeoff, and the airplane departing the runway and impacting a tree.NTSB LAX05LA130Accident · No injuriesLimited investigationFinal reportCessna 421B · Lake Havasu Cit, AZthe fracture of the landing gear shaft roll pin that resulted in a main gear collapse during the taxi.NTSB CHI05LA088Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Imperial, NEThe pilot's inadequate preflight planning which led to fuel exhaustion and subsequent loss of engine power. The soft ground was a factor.NTSB ATL05CA069Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Griffin, GAThe pilot's failure to maintain directional control during the landing roll, which resulted in an on-ground collision with a ditch.NTSB ANC05CA054Accident · No injuriesData collectionFinal reportPiper PA-18 · Bethel, AKThe pilot's failure to compensate for a crosswind during an aborted landing, which resulted in a loss of directional control. A factor associated with the accident was a crosswind.NTSB DFW05CA100Accident · No injuriesData collectionFinal reportCessna 172L · Stephenville, TXThe pilot's improper recovery from a bounced landing, which resulted in a hard landing. A contributing factor was the prevailing crosswind.NTSB DEN05FA047Accident · 1 fatalField investigationFinal reportBeech E55 · Fort Collins, COthe pilot's failure to maintain aircraft control. Contributing factors were the left engine loss of power for reasons undetermined, and the pilot allowing the airspeed to drop below Vmc during an attempted single-engine go-around.NTSB CHI05LA086Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Waunakee, WIThe pilot's inadequate preflight planning and the delay in aborting the landing which resulted in the subsequent insufficient airspeed. Factors associated with the accident were the night light conditions, the fence, and the pole which the airplane contacted.NTSB ATL05CA068Accident · No injuriesData collectionFinal reportCessna 310J · Union City, SCThe pilot's delay in aborting the landing. A contributing factor was the pilot's failure to maintain directional control.NTSB NYC05CA068Accident · No injuriesData collectionFinal reportCanadair CL-600-2A12 · Teterboro, NJThe captain's improper recovery from a bounced. A factor in the accident was windshear.NTSB LAX05CA129Accident · Minor injuriesData collectionFinal reportBeech D50C · Montague, CAThe pilot's inadequate aircraft preflight and failure to verify that an adequate fuel supply was in the right main tank prior to flight, resulting in a fuel starvation induced loss of engine power in the right engine. Also causal was the pilot's failure to…NTSB IAD05LA051Accident · Minor injuriesLimited investigationFinal reportCessna 182N · Marion, OHThe pilot's inadequate in-flight planning/decision which resulted in an encounter with icing conditions and the accretion of ice on the airframe. Also causal was the pilot's improper setting of the flaps in icing conditions in accordance with operating…NTSB IAD05LA050Accident · No injuriesLimited investigationFinal reportPiper PA-31P-350 · Ridgefield, CTThe pilot's improper IFR procedure by flying below the minimum descent altitude, which resulted in the airplane striking trees.NTSB DFW05CA097Accident · No injuriesData collectionFinal reportCessna 152 · Shawnee, OKThe pilot's improper landing flare and his inadequate recovery from a bounced landing. A factor was the prevailing crosswind.NTSB CHI05CA085Accident · No injuriesData collectionFinal reportCirrus Design SR-22 · Atkinson, NEThe pilot's failure to compensate for the wind condition which resulted in a loss of aircraft control while landing. A factor associated with the accident was the gusty crosswind condition that existed at the time of the accident.NTSB LAX05CA128Accident · No injuriesData collectionFinal reportCessna 172N · San Jose, CAthe student pilot's misjudged landing flare, which resulted in a hard landing.NTSB MIA05WA166Accident · No injuriesForeign investigationBritten-Norman BA-2A-8 · Caracas, VenezuelaNTSB MIA05FA085Accident · 2 fatalField investigationFinal reportCommander 114-B · Venice, FLThe pilot's in-flight loss of control during takeoff/initial climb over the water at night due to spatial disorientation. A related factor was the night conditions.NTSB NYC05CA065Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Sussex, NJThe pilot's failure to insure adequate obstacle clearance while conducting a practice forced landing approach, and the flight instructor's failure to take remedial action, which resulted in an in-flight collision with wires.NTSB MIA05LA084Accident · No injuriesLimited investigationFinal reportSwearingen SA227-AC · Miami, FL"This case was modified may 30, 2006." The airplane's inadvertent impact with one of several deer that had entered the airport property and crossed the runway during the landing rollout.NTSB LAX05CA127Accident · No injuriesData collectionFinal reportCessna 172L · Chino, CAthe pilot's inadequate compensation for a gusting crosswind and his failure to maintain directional control.NTSB DEN05LA065Accident · No injuriesLimited investigationFinal reportBeech A36 · Farmington, NMthe pilot's improper soft-field takeoff procedures and failure to maintain control of the aircraft. A contributing factor was the attempted aborted takeoff.NTSB ATL05CA070Accident · No injuriesData collectionFinal reportCessna 152 · Goose Creek, NCThe student pilot's failure to maintain direction control, which resulted in a loss of control and collision with a berm.NTSB ANC05LA053Accident · No injuriesLimited investigationFinal reportCessna 140 · Denali Park, AKThe loss of engine power during takeoff and cruise flight for an undetermined reason, which resulted in an emergency descent/landing, and collision with trees.NTSB WAS05WA009Incident · No injuriesForeign investigationRaytheon Corporate Jets HS 800XP · Milan, ItalyNTSB SEA05WA091Accident · No injuriesForeign investigationBell UH-1F · Banda Ache, IndonesiaNTSB SEA05LA068Accident · 1 fatalLimited investigationFinal reportCessna T337E · Orcas Island, WAThe loss of power for undetermined reasons which resulted in a forced landing and impact with water.NTSB MIA05LA088Accident · 1 fatalLimited investigationFinal reportSchweizer 269D · Atlantic Ocean (Atlantic Ocean)An inflight collision with the ocean for undetermined reasons.NTSB ATL05CA067Accident · No injuriesData collectionFinal reportAviat A1A · Alexander City, ALThe pilot's failure to maintain airspeed which resulted in an inadvertent stall.NTSB MIA05LA083Accident · No injuriesLimited investigationFinal reportCessna 172S · Palm Beach, FLThe flight crews inadvertent encounter with turbulence in clouds while being vectored by ATC while operating in instrument meteorological conditions. A factor in the accident was the ATC personnel's (ARTCC) inadequate weather avoidance assistance.NTSB CHI05LA083Accident · 1 fatalLimited investigationFinal reportMooney M20E · Bloomfield, IAThe pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin. The low altitude was a factor.NTSB CHI05CA087Accident · No injuriesData collectionFinal reportPiper PA-32-300 · Jeffersonville, INThe pilot's inadequate preflight of the aircraft by his failure to detect an open fuel drain which resulted in fuel starvation and the loss of engine power. Contributing factors were the pilot's failure to follow emergency procedures, low ceiling, fog and…NTSB LAX05LA126Accident · No injuriesLimited investigationFinal reportPiper PA-32-301T · Long Beach, CAThe pilot's failure to maintain directional control during the landing rollout.NTSB LAX05LA125Accident · No injuriesLimited investigationFinal reportCessna 182 · Sacramento, CAa fatigue failure of the right side steering link rod for the nose landing gear steering system.NTSB CHI05LA082Accident · 2 fatalLimited investigationFinal reportMatthews Christen Eagle II · Iowa City, IAThe pilot not maintaining airplane control and airspeed, and the stall/spin encountered during aerobatic maneuvering. A factor in the accident was the pilot exceeding the published airplane's aft center of gravity limit and a factor in the pilot rated…NTSB CHI05FA080Accident · 3 fatalField investigationFinal reportPiper PA-28-235 · West Union, IAThe pilot's failure to abort the takeoff, his failure to maintain adequate airspeed during the takeoff, and the pull-up to avoid obstacles which resulted in an inadvertent stall. Factors associated with the accident were the pilot's failure to maintain…NTSB ATL05FA066Accident · 2 fatalField investigationFinal reportCessna T206H · Johns Island, SCThe pilot's failure to follow instrument flight procedures and descent below the published minimum descent altitude, which resulted in an in-flight collision with terrain during an instrument approach.NTSB ANC05LA052Accident · No injuriesLimited investigationFinal reportCub Crafters PA-18 · Fairbanks, AKThe flight instructor's inadequate supervision of the flight, and the dual student's failure to maintain directional control.NTSB SEA05LA067Accident · 2 fatalLimited investigationFinal reportHoover Challenger II STD · La Grande, ORThe pilot's VFR flight into IMC and his failure to maintain clearance with terrain during cruise flight. Factors were the existing weather conditions that included low ceilings, snow, obscuration, and the mountainous, rising terrain.NTSB NYC05WA064Accident · 3 fatalForeign investigationBeech A23A · Ottengruner, Germany