NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 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 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 FTW94LA079Accident · Minor injuriesLimited investigationFinal reportCessna T210H · Mcallen, TXThe pilot's inadvertent stall of the airplane. Factors were the pilot's failure to refuel and the resultant fuel exhaustion.NTSB SEA94LA054Accident · No injuriesLimited investigationFinal reportFokker DR-1 · Auburn, WAThe pilot failed to maintain clearance while maneuvering near another airplane.NTSB DCA94MA033Accident · Minor injuriesClass 1 · MajorFinal reportSaab-Scania 340B · New Roads, LAThe captain's movement of the power levers below flight idle in flight, the inadequate certification requirements and consequent design of the airplane's power levers that permitted them to be moved below the flight idle position into the beta range, either…NTSB CHI94LA071Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Burlington, WIThe student pilot's failure to maintain the proper glideslope.NTSB FTW94LA078Accident · No injuriesLimited investigationFinal reportCessna 182P · Meeker, COFailure by the pilot to maintain directional control of the aircraft during landing roll.NTSB FTW94IA077Incident · No injuriesIncident investigationFinal reportFokker F28 MK O100 · Amarillo, TXThe failure of the outer bearing due to a lack of lubrication.NTSB LAX94LA110Accident · No injuriesLimited investigationFinal reportCessna 140 · Palo Alto, CAThe cfi's inproper supervision of the flight, the dual student's improper recovery from a bounced landing, and the dual student's improper use of the brakes. The cfi's lack of total instructional experience is a factor in this accident.NTSB LAX94LA109Accident · No injuriesLimited investigationFinal reportCessna 182 · Watsonville, CAThe pilot's inadequate preflight inspection by failing to remove the pitot tube cover and delay in his remedial action by not beginning to stop the airplane until it was about 1,000 feet before the end of the runway. The soft terrain and the collapsed nose…NTSB CHI94LA075Accident · Serious injuriesLimited investigationFinal reportCessna 210L · Chesterfield, MOThe pilot-in-command's poorly planned approach. A factor in the accident was the loss of engine power for an undetermined reason.NTSB CHI94LA074Accident · No injuriesLimited investigationFinal reportDouglas DC3C · Anderson, INthe pilot in command's inadequate remedial action after a loss of directional control during the takeoff ground roll. Related factors are the copilot's failure to maintain directional control, and the snow covered, icy runway.NTSB SEA94LA053Accident · No injuriesLimited investigationFinal reportCessna 150 · Springfield, ORFuel exhaustion, and the pilot's poor inflight decision. Factors include the pilot's poor pre-flight planning, and a sign in the path of the landing roll.NTSB MIA94LA063Accident · No injuriesLimited investigationFinal reportBeech 35 · Leesburg, FLThe pilot-in-command's poor evaluation of the weather and failure to remain in visual meteorological conditions, resulting in an in-flight collision with water.NTSB MIA94LA062Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · New Smyrna Bch, FLThe pilot-in-command's failure to maintain airspeed (VSO) while maneuvering, resulting in an in-flight loss of control (inadvertent stall) and subsequent in-flight collision with terrain.NTSB LAX94LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Lovelock, NVThat the pilot's failure to maintain adequate airspeed while on final approach which resulted in an inadvertent stall during the flare.NTSB BFO94LA036Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Newburyport, MAThe pilot not maintaining clearance from the snowbank during final approach. A factor in this accident was the proximity of the snowbank to the active runway.NTSB MIA94LA061Accident · Serious injuriesLimited investigationFinal reportAirbus Industrie A-300 B4-203 · Ormond Beach, FLThe failure of the passenger to follow the visual and oral instructions of the crew to be seated and fasten seat belts.NTSB LAX94LA107Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-301 · Truckee, CAThe pilot's failure to maintain directional control, delay in his remedial action, and failure to raise the flaps. The snow covered runway was a factor in this accident.NTSB LAX94FA106Accident · 1 fatalField investigationFinal reportSikorsky S-58 · San Jose, CAThe pilot's inadequate preflight planning/preparation and subsequent fuel starvation, due to an inadequate supply of fuel. A factor related to the accident was: the proximity of high obstructions.NTSB FTW94GA076Accident · 2 fatalFinal reportBellanca 8GCBC · Usaf Academy, COLoss of control in flight for an undetermined reason.NTSB DCA94IA032Incident · No injuriesIncident investigationFinal reportDouglas DC-9-32 · Chantilly, VAThe flightcrew's failure to maintain directional control during a rejected takeoff. Contributing factors were the wet and icy runway.NTSB ATL94LA045Accident · No injuriesLimited investigationFinal reportCessna 310R · Memphis, TNThe failure of the pilot of N2069C to follow the ATC directive to give way to N3844C, and the inadequate visual lookout by the pilot of N2069C. A factor was the dark night lighting condition at the time of the accident.NTSB ATL94FA046Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Centreville, ALThe pilot's failure to assure that the fuel selector was in the proper position for takeoff.NTSB CHI94LA073Accident · Serious injuriesLimited investigationFinal reportCessna T210M · Olathe, KSthe pilot's failure to follow procedures and directives regarding the positioning of the fuel tank selector to the fullest tank for the landing portion of flight.NTSB BFO94FA032Accident · 1 fatalField investigationFinal reportBeech BE-58 · Newtown, OHFailure of the pilot to maintain control of the aircraft after becoming spatially disorientated in night instrument meteorological conditions (IMC). Factors related to the accident were: the pilot's lack of experience in the type of operation, his lack of…NTSB FTW94LA075Accident · Serious injuriesLimited investigationFinal reportCessna T-210J · Hobart, OKThe pilot's continued VFR flight into IMC. Factors were the weather, the pilot's failure to obtain a weather briefing for the flight, and the dark night conditions.NTSB CHI94MA072Accident · 2 fatalMajor investigationFinal reportCessna 421C · Mccook, NEImproper in-flight planning/decision by the pilot, and the accumulation of airframe ice, which resulted in an inadvertent stall. Factors associated with the accident were: partial failure of both alternators, which resulted in a subsequent electrical system…NTSB BFO94WA125Accident · No injuriesForeign investigationGrumman AA1B · Bayreuth, GermanyNTSB ATL94LA044Accident · No injuriesLimited investigationFinal reportCessna 310A · Dyersburg, TNThe failure of the pilot to attain a proper touchdown point, which resulted in a long landing and an overrun of the runway. Factors were the weather conditions (sky obscuration, low ceiling, fog and drizzle) at the time of the accident, and the wet runway…NTSB LAX94LA104Accident · No injuriesLimited investigationFinal reportBeech 58 · Modesto, CAThe pilot's failure to perform the emergency landing gear extension and other maintenance personnel's inadequate 100-hour inspection. The partial electrical failure and the pilot apprehension/anxiety due to a possible electrical fire were factors in this…NTSB LAX94LA103Accident · No injuriesLimited investigationFinal reportCessna 172N · Livermore, CAThe student pilot's failure to maintain directional and his improper use of the rudder. The student pilot's failure to raise the flaps, the prevailing 90-degree crosswind, and his lack of total experience are factors in this accident.NTSB FTW94FA074Accident · 1 fatalField investigationFinal reportAeronca 7AC · Tulsa, OKWas the inadvertent stall. Factors were the pilots failure to use carburetor heat when weather conditions existed that were conducive to carburetor icing, and his abrupt maneuver to avoid a light pole.NTSB BFO94LA035Accident · No injuriesLimited investigationFinal reportRobinson R-22A · Gaithersburg, MDThe pilot's failure to maintain rotor RPM which led to an in flight loss of control resulting in a collision with the runway and the helicopter rolling over on its side. A factor in this accident was the pilot's lack of total experience flying helicopters.NTSB BFO94FA034Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Bethel, PAthe pilot attempting visual flight rules (VFR) flight into instrument meteorological conditions and the pilot not maintaining clearance from objects/terrain.NTSB MIA94LA060Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Naples, FLThe flight instructor's delayed reaction to take control of the helicopter. Contributing factors were the student pilot's improper use of cyclic and collective controls and his failure to release the flight controls to the flight instructor.NTSB MIA94IA059Incident · No injuriesIncident investigationFinal reportLearjet LR-35A · Key Largo, FLThe failure of the pilot-in-command to maintain the proper glidepath.NTSB LAX94LA105Accident · No injuriesLimited investigationFinal reportRockwell AC-112 · Modesto, CAthe worn/chafed landing gear wire which provided intermittent electrical power to the hydraulic pump.NTSB CHI94LA070Accident · No injuriesLimited investigationFinal reportCessna 150L · Waubay, SDthe pilot-in-command's failure to refuel the airplane prior to fuel exhaustion. A factor in the accident is the false indications on the fuel gauges.NTSB CHI94LA069Accident · Serious injuriesLimited investigationFinal reportPlummer Supercat · Stafford, KSThe pilot's failure to refuel the airplane prior to fuel exhaustion, and his failure to maintain airspeed resulting in an aerodynamic stall. His inadequate training was a factor in the accident.NTSB CHI94FA067Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Waseca, MNContinued VFR flight by the non-instrument rated pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude (or clearance) above the ground. Factors related to the accident were: an inaccurate weather forecast by…NTSB BFO94LA030Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Bennington, VTThe pilot's selection of unsuitable terrain for landing.NTSB ATL94FA043Accident · 2 fatalField investigationFinal reportCulver LCA · Lake City, SCWas the pilot's failure to maintain flying speed while maneuvering the airplane which resulted in the loss of control and the collision with the ground.NTSB SEA94LA056Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Sidney, MTThe pilot's inadequate compensation for the crosswind resulting in loss of directional control.NTSB MIA94FA058Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Pontotoc, MSThe pilot in command's failure to maintain altitude while manuevering resulting in the aircraft colliding with trees and then the ground.NTSB LAX94LA102Accident · 1 fatalLimited investigationFinal reportFurche-Bielsko SZD-48 Jantar · Warner Springs, CAThe pilot's improper remedial action to recover from the spin. The intentional stall/spin was a factor in this accident.NTSB LAX94LA101Accident · 1 fatalLimited investigationFinal reportAviat Christen Eagle II · Ramona, CAA failure of the pilot-in-command to maintain an adequate visual lookout and proper altitude to avoid colliding with rising terrain.NTSB CHI94LA068Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Newberry, MIan engine fire which started as the result of an oil leak around the engine oil filter.NTSB BFO94LA029Accident · No injuriesLimited investigationFinal reportCessna 152 · Plymouth, MAthe pilot's failure to maintain directional control during the flare/touchdown.NTSB ATL94LA042Accident · No injuriesLimited investigationFinal reportCessna 182D · Donalsonville, GAThe pilot's failure to clear the induction systems of excessive fuel.NTSB ANC94LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Anchorage, AKFuel starvation from water and/or ice crystals in the fuel system. A factor in the accident was the improper preflight of the fuel sumps by the pilot-in-command.NTSB SEA94FA052Accident · 1 fatalField investigationFinal reportPiper PA-12 · Idaho Falls, IDThe pilot's failure to maintain clearance from the terrain. Factors include the pilot's poor inflight decision to attempt low level maneuvers in a narrow canyon.