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 CHI91LA127Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · West Branch, MIThe pilot's failure to follow recommeded starting procedures/directives and precautions.NTSB BFO91FA040Accident · 2 fatalField investigationFinal reportCessna 195 · California, MDThe loss of power for undetermined reasons.NTSB ATL91LA079Accident · No injuriesLimited investigationFinal reportCessna 120 · Pinebluff, NCThe pilot's delay in aborting the takeoff. The pilot's failure to calculate the aircraft's performance for the existing conditions was a factor related to the accident.NTSB SEA91LA080Accident · No injuriesLimited investigationFinal reportCessna 172A · Hood River, ORAn inadequately planned approach which resulted in a hard landing. Factors to the accident were rough water landing conditions, poor supervision by the CFI, and the overload condition to the float assembly.NTSB MIA91IA117Incident · No injuriesIncident investigationFinal reportEmbraer EMB-110P1 · Ochopee, FLFailure of the student to use the checklist, inadequate supervision by the pic/cfi, and inadequate supervision by the FAA principle operations inspector.NTSB LAX91LA170Accident · Serious injuriesLimited investigationFinal reportSunrise Ultralight Spitfire II · Elk Grove, CAThe failure of the operator to maintain adequate airspeed.NTSB LAX91LA158Accident · Minor injuriesLimited investigationFinal reportGlasair III SH-3R · Mesa, AZThe mismanagement of the airplane's fuel supply by the pilot and his failure to select a fuel tank containing sufficient fuel for flight which resulted in fuel starvation.NTSB LAX91LA157Accident · No injuriesLimited investigationFinal reportCessna 172N · Stockton, CAThe installation by maintenance personnel of an incorrect gasket that resulted in the loss of the engine magneto.NTSB LAX91FA159Accident · 1 fatalField investigationFinal reportRobinson R22B · Temecula, CAThe failure of the pilot to maintain separation from obstacles (power lines).NTSB DCA91MA033Accident · 23 fatalClass 1 · MajorFinal reportEmbraer EMB-120RT · Brunswick, GAThe loss of control in flight as a result of a malfunction of the left engine propeller control unit which allowed the propeller blade angles to go below the flight idle position. Contributing to the accident was the deficient design of the propeller control…NTSB CHI91LA130Accident · No injuriesLimited investigationFinal reportBeech 58 · Wichita, KSRemedial action was delayed by the instructor pilot. A factor related to the accident was an excessive rate of descent.NTSB CHI91LA121Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Schaumburg, ILThe mechanic's not understanding the identifying marks on the replacement part. A factor in the accident was that the mechanic was provided with an improper part.NTSB CHI91DER02Accident · 1 fatalFinal reportPaulbicke Bede 5B · Park Rapids, MNThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall and subsequent spin.NTSB ANC91LA048Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe pilot's lack of currency with the type of landing gear involved.NTSB NYC91LA101Accident · No injuriesLimited investigationFinal reportBeech 56TC · New Haven, CTFailure of the pilot to maintain directional control after the nose wheel steering system failed.NTSB NYC91LA100Accident · 1 fatalLimited investigationFinal reportMooney M20J · Blue Ash, OHThe failure of the pilot to maintain proper altitude and airspeed during a landing approach, which resulted in a stall and spin at too low an altitude to recover. A factor related to the accident was the lack of recent flight experience by the pilot.NTSB FTW91FA060Accident · 2 fatalField investigationFinal reportCessna 172M · Flippin, ARThe pilot's attempted VFR flight in instrument meteorological conditions and his failure to maintain altitude.NTSB DCA91MA031Accident · 7 fatalClass 1 · MajorFinal reportBell 412SP · Merion, PAThe poor judgement by the captain of the airplane to permit the in-flight inspection after he had determined to the best of his ability that the nose landing gear was fully extended, the poor judgment of the captain of the helicopter to conduct the…NTSB CHI91LA124Accident · Minor injuriesLimited investigationFinal reportCessna C172N · North Liberty, INThe pilot's inadvertent touchdown and inadequate remedial action. Related factors are the low pass maneuver, and the soft terrain.NTSB CHI91DCG01Accident · 1 fatalFinal reportAkins Stinger · Blairstown, MOAn inflight breakup after the pilot encountered weather, lost control inflight, & exceeded the design limits of the airplane. A factor was the pilot's decision to fly into known adverse weather.NTSB ANC91LA047Accident · No injuriesLimited investigationFinal reportCessna 180F · Yukon River, AKA carburetor fuel leak due to inadequate annual inspection. Contributing to the accident was the snow covered terrain.NTSB MIA91LA116Accident · No injuriesLimited investigationFinal reportCessna 150H · Orlando, FLTotal loss of engine power due to fuel exhaustion and failure of the pilot to refuel the fuel tanks before departure.NTSB MIA91LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Vero Beach, FLFailure of maintenance personnel to follow directions of a service bulletin during the major overhaul of the engine. This resulted in failure to detect a foreign object under the crankshaft gear. As a result the crankshaft gear became loose and quit turning…NTSB LAX91LA146Accident · No injuriesLimited investigationFinal reportRobinson R22HP · Camarillo, CAThe failure of the pilot to maintain directional control of the helicopter and apply proper remedial action. Contributing to the accident was the improper selection of the touchdown point and the disregarding of company procedures.NTSB LAX91FA156Accident · 2 fatalField investigationFinal reportHerbert W. Ross RV-4 · Santa Paula, CAThat the pilot inadvertently selected the wrong fuel tank and the passenger interfered with the flight controls when the seat back failed.NTSB FTW91LA059Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Decatur, TXThe instructor's inadequate supervision and the student's failure to relinguish controls.NTSB FTW91LA058Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Hobart, OKThe pilot's failure to maintain clearance with known objects.NTSB BFO91LA042Accident · No injuriesLimited investigationFinal reportBeech P35 · Gilbertsville, KYThe pilot's failue to ensure the gear was fully extended during a precautionary landing after the loss of electrical power for undetermined reasons.NTSB BFO91LA039Accident · No injuriesLimited investigationFinal reportPiper PA-25-235D · Chesapeake, VAThe pilot's failue to maintain adequate airspeed after the loss of engine power for undetermined reasons.NTSB ATL91LA076Accident · No injuriesLimited investigationFinal reportDavid Lowe ULTRA-PUP · Waycross, GAThe failure of the airplane battery, which prohibited the complete extension of the landing gear, resulting in a landing with the nose gear retracted. A factor in the accident was the soft terrain at the selected landing area.NTSB ANC91TF#02Accident · No injuriesClass 3Final reportBell 206B · Umnac Island, AKNTSB NYC91LA098Accident · No injuriesLimited investigationFinal reportCessna 152 · Bayport, NYImproper control response by the pilot, when encountering adverse wind conditions, which resulted in a hard landing. Contributing to the accident was the limited experience of the pilot in this type of airplane.NTSB NYC91FA099Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Naples, NYFlight by the pilot into known icing conditions, which resulted in structural (wing) ice and subsequent loss of aircraft control. The weather condition was a related factor.NTSB LAX91LA172Accident · Minor injuriesLimited investigationFinal reportHughes 369C · Papua, Papua New GuineaThe loss of control of the helicopter due to a restriction of the cyclic control system.NTSB LAX91LA155Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS1-26-D · Warner Springs, CAThat the pilot used poor planning/decision and failed to maintain flying speed. Contributing to his accident was the loss of thermal lift and lack of experience in this type of aircraft.NTSB LAX91LA154Accident · 1 fatalLimited investigationFinal reportMooney M-20E · Lee Vining, CAThe failure of the pilot to maintain adequate altitude to clear mountainous terrain. Contributing to the accident was pilot fatigue due to a lengthy cross country flight.NTSB FTW91DPG03Accident · No injuriesFinal reportGrumman G-164A · Earle, ARA power loss for undetrmined reasons. A factor was the muddy/soft terrain in which the forced landing was performed.NTSB CHI91IA120Incident · No injuriesIncident investigationFinal reportCessna 172RG · West Chicago, ILFailure of the splined shaft on the right main landing gear pivot assembly. A factor related to the incident was inadequate design of the landing gear pivot assembly.NTSB ANC91LA045Accident · No injuriesLimited investigationFinal reportStinson 108 · Fort Greely, AKUnsuitable terrain selected by the pilot for a precautionary landing.NTSB SEA91LA072Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Wamic, ORThe pilot's selection of an empty fuel tank for takeoff.NTSB MIA91WA114Accident · 8 fatalForeign investigationCessna 402B · Ambergrs, BelizeNTSB ATL91LA075Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Pollocksville, NCFailure of the pilot to maintain adequate airspeed, which resulted in a stall/spin.NTSB ATL91FA074Accident · 3 fatalField investigationFinal reportBeech 60 · Kinston, NCThe pilot diverted his attention and failed to maintain control of the aircraft, while maneuvering for a precautionary landing. Factors related to the accident were: the unsecured baggage compartment door and the pilot's inadequate preflight.NTSB ANC91LA044Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Kotzebue, AKFuel contamination (water) in both fuel tanks and fuel lines.NTSB SEA91LA082Accident · No injuriesLimited investigationFinal reportCessna 172M · Ogden, UTThe pilot's poorly planned approached for landing. Factors to the accident were: an excessive airspeed, and the inadequacy of the pilot's recovery from a bounced landing.NTSB SEA91LA077Accident · No injuriesLimited investigationFinal reportBell BH-47G2A · Waitsburg, WAThe improper installation of the main rotor mast nut and lock washer by maintenance personnel which resulted in the separation of the main rotor system.NTSB SEA91FA075Accident · 1 fatalField investigationFinal reportRobinson R-22 Beta · Seattle, WAThe loss of control in flight by the pilot due to his improper preflight preparation in failing to secure cargo which shifted in flight and interfered with the movement of the cyclic control stick.NTSB LAX91LA153Accident · No injuriesLimited investigationFinal reportPiper J3 · Arbuckle, CAThat the pilot used excessive brakes during the landing roll-out.NTSB DEN91LA058Accident · Minor injuriesLimited investigationFinal reportCessna 172B · La Junta, COThe pilot's failure to maintain adequate airspeed and the resultant inadvertent stall. The pilot's failure to raise the flaps was a factor in the accident.NTSB ANC91LA049Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Alexander Creek, AKThe engine failure resulting from fuel screen contamination . A factor was the lack of suitable terrain for the forced landing.