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 DCA05WA040Incident · No injuriesForeign investigationBoeing 747-400 · Manchester, United KingdomNTSB ANC05LA042Accident · No injuriesLimited investigationFinal reportPiper J-5A · Kenai, AKThe pilot's selection of unsuitable terrain for a precautionary landing, which resulted in a collision with a snow berm during the landing flare. Factors contributing to the accident were flat light conditions, the presence of a snow berm along the edge of a…NTSB MIA05LA060Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Avon, MSThe pilot's failure to maintain airspeed while maneuvering at a low altitude, resulting in an inadvertent stall/mush, and impact with terrain.NTSB LAX05LA100Accident · 1 fatalLimited investigationFinal reportAyres S2R · Firebaugh, CAthe loss of engine power during takeoff climb resulting from the fatigue failure of one of the compressor turbine blades; the cause of the fatigue failure could not be definitively determined.NTSB DFW05LA074Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Cameron, LAFuel starvation due to a blocked and collapsed fuel nozzle screen, resulting from a contaminated fuel source/facility. Factors were the inadequate maintenance/inspection of fuel sources, and the lack of suitable terrain (high sea state) for the forced landing…NTSB ATL05LA051Accident · Serious injuriesLimited investigationFinal reportMooney 20P · Smith, ALMaintenance personnel failure to properly torque the cylinder head during installation that resulted in the separation from the engine assembly and the subsequent loss of power.NTSB ATL05CA054Accident · No injuriesData collectionFinal reportPiper PA-22 · Holly Ridge, NCThe CFI's improper use of the rudder control and normal braking during the landing roll that resulted in the collapse of the nose gear assembly.NTSB SEA05CA050Accident · No injuriesData collectionFinal reportAviat Husky A-1 · Kalispell, MTThe pilot's failure to maintain clearance from a tree located off the departure end of his private airstrip during an aborted landing attempt. Factors include trees located near the departure end of the runway.NTSB LAX05CA098Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Chandler, AZthe students pilot's failure to maintain directional control resulting in a collision with the taxiway sign.NTSB DEN05LA057Accident · No injuriesLimited investigationFinal reportCessna P210N · Lander, WYthe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA05LA049Accident · No injuriesLimited investigationFinal reportMooney M20K · Roseburg, ORA fractured piston pin that resulted in a loss of engine power and subsequent forced landing. Factors include rough/uneven mountainous terrain.NTSB MIA05LA059Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Brookhaven, MSThe pilot's inadequate compensation for wind and his failure to maintain control of the airplane during landing, which resulted in the airplane ground looping.NTSB MIA05LA058Accident · Serious injuriesLimited investigationFinal reportInterplane Sro Skyboy · Zephyrhills, FLThe instructors in-flight loss of control due to the flight controls being jammed for undetermined reasons.NTSB DFW05CA070Accident · Minor injuriesData collectionFinal reportRobinson R22 · Owasso, OKThe flight instructor's failure to verify that the student had the flight controls and his delayed remedial action.NTSB DEN05LA058Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Montrose, COthe pilot's improper in-flight planning during the descent which resulted in partial loss of engine power due to carburetor ice. Contributing factors were the pilot's failure to select carburetor heat during the descent and unsuitable terrain for the forced…NTSB DCA05MA037Accident · 8 fatalClass 1 · MajorFinal reportCessna 560 · Pueblo, COthe flight crew's failure to effectively monitor and maintain airspeed and comply with procedures for deice boot activation on the approach, which caused an aerodynamic stall from which they did not recover. Contributing to the accident was the Federal…NTSB ANC05LA041Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Kipnuk, AKThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in a departure from the runway and collision with a snow bank. A factor contributing to the accident was snow-covered terrain.NTSB ANC05LA036Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Talkeetna, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in ski assembly damage during the takeoff run from a frozen, snow-covered lake, and subsequent nose over during an emergency landing. Factors contributing to the accident were an overload…NTSB LAX05FA099Accident · 2 fatalField investigationFinal reportBeech 95 · Calistoga, CAThe pilot's inadequate preflight and in-flight planning/decision, which resulted in continued VFR flight into instrument meteorological conditions at an altitude insufficient to ensure adequate terrain clearance and impact with rising terrain.NTSB IAD05LA038Accident · Minor injuriesLimited investigationFinal reportGrumman G-21A · Penn Yan, NYThe flight instructor's inadequate planning/decision and his remedial action to conduct or recover from a simulated emergency procedure.NTSB ANC05LA035Accident · Minor injuriesLimited investigationFinal reportBellanca 8GCBC · Koyukuk, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in an in flight collision with the snow during takeoff initial climb. A factor contributing to the accident was soft snow conditions.NTSB ANC05FA034Accident · 2 fatalField investigationFinal reportBeech 35-C33 · Clearwater, FLThe loss of engine power during initial climb due to fuel exhaustion, the pilot's failure to refuel the airplane, and the pilot's failure to maintain minimum airspeed, which resulted in an inadvertent stall and uncontrolled descent into a residence.NTSB LAX05CA096Accident · No injuriesData collectionFinal reportAeronca 7EC · Grass Valley, CAthe pilot's failure to maintain directional control.NTSB LAX05CA095Accident · Minor injuriesData collectionFinal reportRobinson R44 · Lake Arrowhead, CAthe certified flight instructor's failure to adequately compensate for wind conditions and his selection of terrain unsuitable for a safe takeoff which resulted in a dynamic rollover.NTSB ANC05FA030Accident · 2 fatalField investigationFinal reportBeech K35 · Leesburg, FLAn abrupt maneuver performed by the pilot at a low altitude, and his failure to maintain adequate airspeed, which precipitated an inadvertent stall and impact with terrain.NTSB DFW05WA071Accident · 2 fatalForeign investigationTwin Commander Acft. 685 · Toluca, MexicoNTSB DFW05CA068Accident · No injuriesData collectionFinal reportBeech BE77 · Angleton, TXThe loss of engine power as result of fuel exhaustion due to the pilot's improper in-flight planning. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX05LA105Accident · Serious injuriesLimited investigationFinal reportSaab-Scania Saab 340B · Los Angeles, CAthe in-flight encounter with turbulence.NTSB ANC05LA033Accident · 2 fatalLimited investigationFinal reportTwente Pitts Model 12 · Marion, MSThe pilot's failure to maintain control of the airplane while performing a low altitude, aerobatic maneuver, which resulted in an uncontrolled descent, and an in-flight collision with terrain. A factor associated with the accident was the initiation of a low…NTSB ANC05LA032Accident · Minor injuriesLimited investigationFinal reportJohnson Revolution Mini 500 · Isabela, PRThe loss of engine power during cruise flight for an undetermined reason, which resulted in an autorotation and collision with terrain.NTSB ANC05CA031Accident · Minor injuriesData collectionFinal reportDickson RV-7A · Panacea, FLThe pilot's misjudged landing flare, which resulted in a hard landing, the collapse of the nose gear, and subsequent nose over.NTSB NYC05IA052Incident · No injuriesIncident investigationFinal reportCessna 402C · Hyannis, MAThe mechanic's inadequate inspection, which failed to discover cracks in the left wing spar around wing station 114.NTSB LAX05FA092Accident · 2 fatalField investigationFinal reportCessna P210N · Lebec, CAthe pilot's in-flight loss of control due to the flight's encounter with unforecasted localized mountain wave activity with severe to potentially extreme turbulence, downdrafts, and rotors.NTSB DCA05WA061Accident · No injuriesForeign investigationBoeing 737-200 · Achmad Yani, IndonesiaNTSB CHI05LA071Accident · No injuriesLimited investigationFinal reportTwin Commander Acft. 680V · Fort Wayne, INThe malfunction of the landing gear extension assembly during approach for undetermined reasons.NTSB CHI05LA069Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Bolivar, MOA loss of engine power due to the pilot's inaccurate preflight and inflight planning which resulted in an inadequate fuel supply for the flight, and the subsequent fuel exhaustion. A factor associated with the accident was the trees that the airplane…NTSB NYC05WA051Accident · 2 fatalForeign investigationCessna 182Q · Villac, FranceNTSB LAX05FA090Accident · 1 fatalField investigationFinal reportAmerican AA1B · Petaluma, CAThe pilot's failure to maintain an adequate airspeed above the stall speed (Vso) while maneuvering to a landing area that resulted in a stall-spin. Factors in the accident were the fuel starvation induced loss of engine power due to the pilot's fuel system…NTSB LAX05CA093Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Roosevelt, AZthe pilot's failure to maintain directional control.NTSB DCA05RA036Accident · 3 fatalForeign investigationMcDonnell Douglas MD-902 · Shanghai, ChinaNTSB CHI05LA070Accident · No injuriesLimited investigationFinal reportCessna 172N · Grafton, NDThe pilot's inadequate compensation for the wind conditions which resulted in a loss of directional control during the landing. Factors associated with the accident were the crosswind condition and the snow bank.NTSB CHI05CA072Accident · No injuriesData collectionFinal reportGulfstream American 690C · Indianapolis, INThe pilot's failure to maintain directional control during landing touchdown and rollout. Contributing factors were the pilot's inadequate compensation for the crosswind condition, the runway light which the aircraft struck and the muddy grass area…NTSB ATL05WA050Accident · 2 fatalForeign investigationCessna 182Q · Limoges Bellega, FranceNTSB ANC05LA029Accident · No injuriesLimited investigationFinal reportBeech A36 · Bay St. Louis, MSThe pilot's failure to use the manual emergency landing gear extension mechanism during the approach to land, which resulted in the electrically actuated main landing gear collapsing during the landing roll. A factor associated with the accident is an…NTSB SEA05LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Superior, MTA loss of engine power due to the pilot's inadequate planning/decision and improper fuel management, which resulted in fuel starvation. A contributing factor was the berm.NTSB LAX05LA094Accident · Serious injuriesLimited investigationFinal reportCameron Balloons A-250 · Cave Creek, AZthe pilot's inadequate handling of the balloon during boarding resulting in a passenger falling and sustaining a serious injury.NTSB CHI05CA068Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Larimore, NDThe CFI's delay in applying remedial action which resulted in a loss of directional control of the airplane. Factors associated with the accident were the student's excessive application of rudder and the snow bank which the airplane contacted.NTSB ANC05LA027Accident · 3 fatalLimited investigationFinal reportCessna U206 · Port Alsworth, AKThe pilot's continued VFR flight into instrument meteorological conditions (IMC), his improper in-flight planning and decision making, and his failure to maintain clearance from terrain while maneuvering to reverse direction at a low altitude. Factors…NTSB ATL05LA049Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Concord, NCThe loss of engine power due to the failure of the fuel pump which resulted in fuel starvation.NTSB ANC05LA026Accident · No injuriesLimited investigationFinal reportCessna 411A · Hollywood, FLThe failure of the right main landing gear locking mechanism during the landing roll, which resulted in the collapse of the right main landing gear.