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 LAX05LA239Accident · 1 fatalLimited investigationFinal reportAs+ AC4 · Sparks, NVthe pilot's failure to maintain an adequate airspeed while performing S-turns on final approach, which resulted in a stall and uncontrolled descent into terrain. A contributing factor in the accident was the pilot's impairment due to ingestion of an…NTSB IAD05CA104Accident · No injuriesData collectionFinal reportCessna 172S · Charlottesville, VAThe student pilot's improper flare which resulted in a hard landing.NTSB DEN05TA113Accident · Minor injuriesFinal reportHughes 369FF · Loveland, COThe pilot's failure to maintain aircraft control due to delayed remedial action during the encounter with the loss of tail rotor effectiveness. Contributing factors were the pilot's inadequate preflight performance planning, and the inadequate supervision by…NTSB CHI05CA193Accident · Minor injuriesData collectionFinal reportPiper PA-22 · Plainwell, MIThe loss of engine power on downwind due to carburetor icing, and the unsuitable terrain the pilot encountered during the forced landing. A factor was the soft terrain.NTSB LAX05CA238Accident · No injuriesData collectionFinal reportCessna 152 · Rio Vista, CAthe student pilot's inadequate recovery from a bounced landing and his failure to maintain directional control of the airplane during landing rollout. A contributing factor was the student's failure to divert to an airport with less severe crosswind…NTSB IAD05LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Denton, MDA loss of engine power for undetermined reasons.NTSB DFW05WA184Accident · 2 fatalForeign investigationBell 412 · Ciudad Carmen, MexicoNTSB CHI05FA189Accident · 3 fatalField investigationFinal reportPiper PA-30 · Aurora, MOThe pilot not maintaining adequate airspeed and aircraft control during initial climb, which resulted in an inadvertent stall/spin at a low altitude. A factor to the accident was the pilot operating the airplane over its certified maximum gross weight.NTSB ATL05CA134Accident · No injuriesData collectionFinal reportAircraft Mfg & Dev. CH2000 · Winston-Salem, NCThe student pilot's misjudged flare and his improper recovery from a bounced landing resulting in a stall and hard landing.NTSB ATL05CA133Accident · No injuriesData collectionFinal reportPiper PA-34-200 · Atlanta, GAThe pilot's improper use of normal braking and the failure to maintain directional control during landing. Also causal was the instructor's inadequate supervision of the flight which resulted in a collision with the ground.NTSB ATL05CA132Accident · No injuriesData collectionFinal reportCessna 172P · Savannah, GAThe pilot's failure to maintain directional control on landing roll out resulting in a ground loop, and on ground collision of the right wing with the ground.NTSB SEA05LA147Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Yellow Pine, IDThe pilot's selection of unsuitable terrain for takeoff, and his failure to maintain directional control after the aircraft's right main gear contacted a small dirt mound during the takeoff roll at the remote grass airstrip. Factors include the pilot's…NTSB SEA05LA145Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Bonners Ferry, IDThe pilot's failure to maintain terrain clearance while maneuvering. Mountainous terrain was a factor.NTSB IAD05LA099Accident · Minor injuriesLimited investigationFinal reportCessna 525 · Old Bridge, NJThe pilot's improper preflight planning, his failure to consult performance data, and his failure to obtain the proper touchdown point, which resulted in a runway overrun. Contributing factors to the accident were the excessive airspeed, overweight condition,…NTSB DEN05LA112Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Grand Junction, COthe pilot's failure to maintain aircraft control during aborted landing and failure to maintain airspeed, which resulted in an inadvertent stall. A contributing factor was the encounter with wind shear during final approach and landing.NTSB CHI05CA195Accident · No injuriesData collectionFinal reportCessna 180 · Bowstring, MNThe unsuitable water conditions for takeoff selected by the pilot and his inability to maintain aircraft control in the rough water. Contributing factors were the aborted takeoff initiated by the pilot, the rough water conditions and the high, gusty winds.NTSB ATL05CA166Accident · No injuriesData collectionFinal reportBeech 35 · Carthage, NCThe pilot's excessive braking resulting in a loss of control and subsequent impact with gully. A related factor was the tailwind.NTSB SEA05WA151Accident · Minor injuriesForeign investigationCessna 340 · Bangalore, IndiaNTSB SEA05LA144Accident · No injuriesLimited investigationFinal reportCessna 180 · Prospect, ORThe pilot's inadequate in-flight decision to perform a wheel landing with a 5 to 10 knot tail wind, and his subsequent loss of aircraft directional control during the landing roll. A tailwind and soft terrain were factors.NTSB MIA05LA135Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Gulfport, MSA loss engine power for undetermined reasons, that resulted in a forced landing, and damage to the helicopter during the landing.NTSB LAX05WA298Accident · No injuriesForeign investigationBell 205A-1 · Lac de la Solit, CanadaNTSB LAX05LA237Accident · No injuriesLimited investigationFinal reportCessna A188B · Bishop, CAthe failure of the tailwheel mount during the landing roll, which resulted in a ground loop.NTSB LAX05LA236Accident · No injuriesLimited investigationFinal reportSergent Great Lakes 2T1A · Phoenix, AZthe pilot's failure to maintain directional control on landing roll, which resulted in a ground loop and nose over of the airplane.NTSB IAD05RA102Accident · 6 fatalForeign investigationPilatus PC-6 · Brasilito, Costa RicaNTSB DFW05LA183Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Pollock, LAThe loss of engine power due to a loose engine lubrication system component in the crankcase. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI05CA187Accident · No injuriesData collectionFinal reportMcDaniels Kitfox Classic IV · Bagley, MNThe pilot's inadvertent lift-off and failure to maintain adequate airspeed while recovering from a loss of directional control during landing. Contributing factors to the accident were the pilot's inadequate wind compensation and failure to maintain aircraft…NTSB LAX05CA232Accident · No injuriesData collectionFinal reportRobinson R-22 Beta II · Mesa, AZthe improper use of the throttle and antitorque pedal by the pilot undergoing instruction, and the inadequate supervision of the flight by the certified flight instructor.NTSB IAD05CA098Accident · No injuriesData collectionFinal reportGrumman G164A · Williamstown, NJThe pilot's misjudgment of distance/altitude, and his failure to maintain obstacle clearance.NTSB DFW05LA190Accident · No injuriesLimited investigationFinal reportBell 47G-4A · Black Oak, ARThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN05LA111Accident · Serious injuriesLimited investigationFinal reportGates Learjet 35A · Eagle, COthe pilot's improper flare resulting in the hard landing and the fractured nose gear attachment, and the subsequent loss of control. Factors contributing to the accident were the high airspeed on approach, the pilot's improper in-flight planning/decision, and…NTSB DEN05LA110Accident · Minor injuriesLimited investigationFinal reportCessna TU206F · Vernal, UTThe pilot's failure to maintain aircraft control during takeoff. Factors contributing to the accident were the soft dirt airstrip, the low airspeed and the stall/mush.NTSB CHI05LA190Accident · No injuriesLimited investigationFinal reportMooney M20M · White Cloud, MIA loss of engine power during cruise flight due to the mechanic's improper maintenance, the disconnected oil line, the oil leak from the disconnected line, and the unsuitable terrain the pilot encountered during the forced landing. Factors were the outside…NTSB CHI05LA188Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Langdon, NDThe pilot's failure to maintain clearance from the terrain while attempting an abrupt turning maneuver at a low altitude.NTSB ATL05CA131Accident · No injuriesData collectionFinal reportCessna 525A · Newnan, GAThe pilot's delay in aborting the landing and his failure to maintain obstacle clearance. Contributing factors were hydroplaning condition, and the localizer antenna.NTSB ANC05CA102Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Karluk, AKA collision with a deer on the runway during the landing roll, which resulted in substantial damage to the tail of the airplane.NTSB SEA05CA143Accident · No injuriesData collectionFinal reportBeech A36 · Sequim, WAThe temporary loss of engine power for an undetermined reason during the takeoff initial climb.NTSB SEA05CA142Accident · No injuriesData collectionFinal reportBeech H-35 · Oregon City, ORThe unattended animal on the runway during the landing, which caused the pilot to pull up and land a second time, resulting in an overrun. A factor contributing to the accident was the inability to abort the landing due to obstacles at the end of the runway.NTSB LAX05GA231Accident · 2 fatalFinal reportEurocopter France EC120B · Fair Oaks, CAThe failure of the constant delta P diaphragm in the fuel control unit, which resulted in an increased fuel flow and subsequent catastrophic failure of the engine. The diaphragm's failure was the result of improper installation by the engine manufacturer. A…NTSB LAX05CA235Accident · No injuriesData collectionFinal reportCessna T210M · TwentyninePalms, CAthe pilot's failure to verify the current local wind condition that resulted in his selection of the wrong runway and an inadvertent downwind landing, a runway overrun and a ground collision with objects. A factor in the accident was the short runway and its…NTSB LAX05CA233Accident · Minor injuriesData collectionFinal reportCessna 170B · Prescott, AZthe pilot's misjudged flare, and excessive use of the elevator control, which resulted in a failure to maintain adequate airspeed and a stall/mush.NTSB DFW05LA182Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Bonita, LAThe failure of the pilot to maintain adequate visual lookout, which resulted in a midair collision.NTSB DFW05CA181Accident · No injuriesData collectionFinal reportMesserschmitt BK-117 B-2 · Houston, TXThe separation of the left passenger door due to worn attaching hardware.NTSB DEN05LA118Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Englewood, COthe pilot not maintaining clearance from the portable helipad during taxi after landing resulting in the airplane colliding with it. Factors contributing to the accident were the pilot's selection of a taxi route through a non-movement area, his inability to…NTSB CHI05FA192Accident · No injuriesField investigationFinal reportAerospatiale AS365N · Valparaiso, INThe loose tail rotor drive shaft coupling due to its improper installation by the operator's maintenance personnel, which resulted in the failure of the tail rotor drive shaft. An additional cause was the inability of the pilot to maintain control of the…NTSB CHI05CA185Accident · Minor injuriesData collectionFinal reportAero Commander S2R · Walnut, ILFuel exhaustion due to the pilot's inadequate in-flight planning/decision. A contributing factor was the corn field.NTSB CHI05CA184Accident · Minor injuriesData collectionFinal reportHirsch RV-6A · Oshkosh, WIThe pilot's failure to maintain directional control during the takeoff. Contributing factors were the uneven (rough) runway surface and the fence.NTSB CHI05LA186Accident · No injuriesLimited investigationFinal reportBell 206L-1 · West Plains, MOA loss of engine power for undetermined reasons during the intentional autorotation. The pilot's misjudgment of the touchdown flare leading to a hard landing was an additional cause. A contributing factor was the intentional autorotation.NTSB ATL05CA130Accident · Minor injuriesData collectionFinal reportJabiru SK0007 · Aiken, SCThe loss of engine power for undetermined reasons.NTSB NYC05LA119Accident · No injuriesLimited investigationFinal reportPratt Ultravia Pelican-PL · Middlebury, VTA partial loss of engine power for undetermined reasons.NTSB MIA05CA134Accident · No injuriesData collectionFinal reportBell 206B · San Juan, PRThe inadequate preflight/planning by the pilot for his initiation of the flight with inadequate fuel supply, and his failure to maintain main rotor rpm following a total loss of engine power due to fuel exhaustion which resulted in a hard landing.