NTSB investigations, 2005
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 SEA06LA003Accident · No injuriesLimited investigationFinal reportBeech B-60 · Arlington, WAMain landing gear collapse during the landing rollout for undetermined reasons.NTSB LAX05CA322Accident · No injuriesData collectionFinal reportCessna 172P · Reno, NVthe pilot's failure to maintain control of the airplane while taxiing in gusty wind conditions.NTSB DFW05FA251Accident · 2 fatalField investigationFinal reportCessna 150M · Crystal Springs, MSThe pilot's failure to retract the flaps during the go-around and his failure to maintain airspeed, which resulted in an inadvertent stall. A contributing factor was the dark night conditions.NTSB ATL06CA001Accident · Minor injuriesData collectionFinal reportBeech D-95A · Greensboro, NCThe pilot mistakenly shut down the operating engine when the passenger interfered with the rudder pedals as he attempted to identify the inoperative engine.NTSB ANC05CA151Accident · No injuriesData collectionFinal reportCessna 182 · Bethel, AKThe pilot's misjudged distance and speed, which resulted in an overrun and a nose over during the landing roll. A factor associated with the accident was the dusk lighting conditions.NTSB SEA05MA202Accident · 3 fatalMajor investigationFinal reportAgusta A109A II · Edmonds, WALoss of control for an undetermined reason during maneuvering flight, which resulted in an in-flight collision with water.NTSB MIA05WA165Accident · 1 fatalForeign investigationCessna 182 · Barinas, VenezuelaNTSB MIA05LA164Accident · No injuriesLimited investigationFinal reportNorth American T-28C · Arcadia, FLA loss of engine power due to the failure of the master rod bearing.NTSB IAD05LA144Accident · Serious injuriesLimited investigationFinal reportHoward Whyte Nieuport 28 · Dayton, OHA loss of engine power due to the installation of incorrect spring type terminal contacts which were accidentally supplied by the engine distributor.NTSB DEN05LA150Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Longmont, COthe failure of the left rudder cable resulting in a loss of directional control by the pilot. Contributing to the accident was the improper repair procedures on the seat frame.NTSB CHI05LA276Accident · 1 fatalLimited investigationFinal reportStits Playboy SA3B Lightning · Kimball, NEThe inadvertent stall and low airspeed by the pilot following takeoff. Contributing factors were the low altitude at the time of occurrence, the high density altitude, and the propeller.NTSB ATL05CA165Accident · No injuriesData collectionFinal reportCessna C172F · Sparta, TNThe pilot's delay in applying carburetor heat that resulted in the loss of engine power due to carburetor ice.NTSB ANC05LA150Accident · Minor injuriesLimited investigationFinal reportCessna 550 · Ft Yukon, AKThe pilot's improper use of anti-icing equipment during cruise flight, which resulted in ice ingestion into both engines (foreign object damage), the complete loss of engine power in both engines, and an emergency descent and landing on tree covered terrain.…NTSB LAX05CA320Accident · No injuriesData collectionFinal reportAeronca 7AC · Snelling, CAthe loss of engine power for undetermined reasons.NTSB DFW05CA253Accident · No injuriesData collectionFinal reportCessna 172S · Batesville, TXThe pilot's failure to maintain clearance from the tree. A contributing factor was the gusty winds.NTSB SEA05FA201Accident · 2 fatalField investigationFinal reportCessna P210N · Salmon, IDThe pilot's failure to obtain airspeed during the initial takeoff climb, which resulted in a stall/mush and subsequent collision with terrain.NTSB LAX05LA321Accident · 1 fatalLimited investigationFinal reportCessna 150 · Taft, CAThe pilot's failure to maintain terrain clearance while maneuvering. The mountainous terrain was a factor.NTSB DEN05CA149Accident · No injuriesData collectionFinal reportCessna 206 · Brigham City, UTthe pilot's improper in-flight planning and decision making and failure to maintain aircraft control during the ground roll.. Contributing to the accident was the soft dirt.NTSB ATL05CA164Accident · No injuriesData collectionFinal reportMaule MT-7-235 · Guyton, GAThe pilot's improper recovery from a bounced landing, and improper flare, which resulted in a hard landing.NTSB SEA05WA203Accident · 2 fatalForeign investigationHughes 269C · Daisen, JapanNTSB MIA05WA162Accident · 1 fatalForeign investigationPiper PA-36-375 · Puerta del Segu, SpainNTSB LAX05LA319Accident · Minor injuriesLimited investigationFinal reportRose Kitfox · Hesperia, CAa loss of engine power due to a loose master ignition relay wire.NTSB CHI05CA275Accident · No injuriesData collectionFinal reportCessna T206H · Sturgeon Bay, WIThe unexpected wave that the airplane encountered during the landing flare.NTSB MIA05CA161Accident · Minor injuriesData collectionFinal reportVans RV-3 · Bell, FLThe pilot's failure to maintain visual lookout during a VFR approach toward the runway resulting in-flight collision with trees. Factors in this accident are no lights for the grass strip runway and attempting to land in low natural light visibility…NTSB LAX05LA318Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Pioche, NVcontrolled flight into mountainous terrain due to the pilot's inadequate preflight planning and preparation and his inadequate in-flight decisions, which created a low fuel state emergency situation that led directly to the CFIT during flight assist efforts…NTSB LAX05LA317Accident · No injuriesLimited investigationFinal reportCessna A185F · Tracy, CAloss of engine power for undetermined reasons.NTSB DFW05WA254Accident · 1 fatalForeign investigationBell UH-1H · Pisa Flores, MexicoNTSB CHI05LA277Accident · No injuriesLimited investigationFinal reportCessna 560XL · Columbus, OHThe collapse of the nose landing gear for undetermined reasons.NTSB NYC05CA147Accident · No injuriesData collectionFinal reportCessna 182 · Southampton, NYThe pilot's failure to maintain directional control while landing.NTSB MIA05CA163Accident · No injuriesData collectionFinal reportPiper PA-25-235 · Opa Locka, FLThe pilot's failure to maintain airspeed, during a banner pick up, resulting in a stall/mush and collision with terrain during the uncontrolled descent.NTSB IAD05CA148Accident · No injuriesData collectionFinal reportSchweizer SGS-2-33A · Windsor, VAThe solo student pilot's loss of control during landing.NTSB SEA05MA199Accident · 3 fatalClass 1 · MajorFinal reportAerospatiale AS350BA · Haena, HIThe pilot's decision to continue flight into adverse weather conditions, which resulted in a loss of control due to an encounter with a microburst. Contributing to the accident was inadequate Federal Aviation Administration surveillance of Special Federal…NTSB SEA05CA200Accident · Minor injuriesData collectionFinal reportMcDonnell Douglas 369E · Medford, ORIn-flight collision with terrain during a precautionary landing. Factors include instrument meteorological conditions and pilot disorientation.NTSB LAX05WA323Accident · 2 fatalForeign investigationBeech A36 · Tenterfield, NS, AustraliaNTSB IAD05LA142Accident · 2 fatalLimited investigationFinal reportAir Creation Clipper 912 · Millstone, NJThe pilot's failure to maintain control of the airplane, which resulted in an uncontrolled descent and impact with trees.NTSB IAD05CA141Accident · Serious injuriesData collectionFinal reportLindstrand Balloons 77A · Louisville, KYThe ground crewman's failure to release the basket of the balloon when it resumed flight during the landing phase. A factor in the accident was the wet grass at the landing site.NTSB DEN05CA147Accident · No injuriesData collectionFinal reportCessna T210L · Las Animas, COthe loss of engine power due to fuel exhaustion. Contributing factors were the pilot's inadequate preflight planning and lack of suitable terrain for the forced landing.NTSB CHI05FA274Accident · 3 fatalField investigationFinal reportRobinson R44 · Drummond, WIClearance not obtained/maintained by the pilot during an unknown phase of flight. Contributing factors were the improper use of procedures by the pilot, the inadequate surveillance of the operation by company/management, and the wire.NTSB NYC05CA146Accident · No injuriesData collectionFinal reportCessna 172P · Mitchellville, MDThe pilot's failure to maintain directional control during landing.NTSB MIA05CA160Accident · No injuriesData collectionFinal reportBell 206B3 · Titusville, FLThe flight instructor's improper flare resulting in a hard landing and main rotor contact with tail boom.NTSB LAX05LA315Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Fall River Mill, CAthe pilot's inadequate compensation for the crosswind condition and failure to maintain runway alignment during landing.NTSB LAX05CA314Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Kamuela, HIThe student's misjudged landing flare, and the instructor's inadequate supervision and delayed remedial action. A factor in the accident was the high density altitude.NTSB IAD05CA140Accident · No injuriesData collectionFinal reportBeech BE-36 · Farmingdale, NYThe pilot's improper recovery from a bounced landing.NTSB CHI05FA272Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-36 · West Memphis, ARThe pilot's improper in-flight decision not to land at the departure runway or other available airports during the emergency descent, and his failure to maintain clearance from a vehicle and terrain. Contributing factors were a false engine fire warning…NTSB SEA05CA197Accident · No injuriesData collectionFinal reportCessna 180H · Yelm, WAThe mixture control linkage separation as a result of a missing retaining nut and washer on the mixture cable attach bolt. Inadequate maintenance inspection and fences were factors.NTSB NYC05LA145Accident · No injuriesLimited investigationFinal reportEurocopter Deutschland BK-117-B2 · Columbus, OHThe pilot's failure to maintain aircraft control during the landing flare, which resulted in a hard landing. A factor associated with this accident was a tailwind.NTSB LAX05IA312Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320 · Los Angeles, CAThe fatigue failure of two anti-rotation lugs due to repeated cyclic pre-landing tests, which allowed the nosewheels to deviate from the 0-degree position on landing gear retraction. A contributing factor was the design of the Brake Steering Control Unit…NTSB LAX05CA313Accident · No injuriesData collectionFinal reportHiller UH 12-E · Five Points, CAThe pilot's failure to refuel the helicopter, which resulted in fuel exhaustion.NTSB DFW05CA248Accident · No injuriesData collectionFinal reportPiper PA-46T · El Reno, OKThe improper flare which resulted in a hard landing. A related factor was the instructor's delayed remedial action.NTSB DFW05CA247Accident · Minor injuriesData collectionFinal reportSmith, Ted Aerostar 601P · Mexia, TXThe pilot's failure to maintain clearance from the barn. Contributing factors were the pilot's inadequate preflight planning/preparation and the high-density altitude.