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 MIA91LA121Accident · No injuriesLimited investigationFinal reportBeech A36 · Punta Gorda, FLDelay of the pilot to abort the takeoff from the private grass airstrip resulting in the airplane overrunning the runway and colliding with a ditch.NTSB LAX91LA177Accident · No injuriesLimited investigationFinal reportPiper PA28-236 · Gualala, CAThat the pilot failed to properly use the flight controls and to maintain directional control. Contributing to this accident were the gusty crosswind conditions that existed at the time of the accident.NTSB DEN91LA060Accident · No injuriesLimited investigationFinal reportCessna 172P · Lehi, ARThe pilot's failure to maintain aircraft control. Factors were: the wet runway and resultant hydroplaning.NTSB CHI91DEP04Accident · Minor injuriesFinal reportBrault Glasair SH2F · Green Bay, WIThe pilot in command's failure to refuel the aircraft prior to departure. A factor contributing to the accident was the unporting of the fuel pick up line in fuel tank during abrupt or negative 'g' maneuvers.NTSB SEA91IA081Incident · Minor injuriesIncident investigationFinal reportBoeing 737-222 · Seattle, WATurbine blade failure from fatigue. Factors to the incident were inoperative engine fire extinguisher, inadequate service of aircraft and delayed deployment of emergency slide.NTSB NYC91LA111Accident · No injuriesLimited investigationFinal reportCessna 150G · Phillipsburg, OHThe failure of the pilot to compensate for crosswind conditions during landing, and allowing the airplane to drift off the runway onto soft terrain. A factor relating to the accident was the decision of the pilot to attempt a landing with strong crosswinds.NTSB MIA91LA120Accident · No injuriesLimited investigationFinal reportAeronca 7CCM · Lakeland, FLImproper ATC clearance by ground personnel and poor decision by the pilot to taxi behind an airplane holding on a runway.NTSB LAX91LA171Accident · No injuriesLimited investigationFinal reportPiper PA24-250 · Casa Grande, AZThat the pilot failed to maintain proper alignment during the landing roll on the narrow airstrip.NTSB FTW91LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Durant, OKThe pilot's failure to maintain proper alignment during the flare.NTSB CHI91LA129Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Griffith, INContaminated fuel in the carburetor, and inadequate inspection/maintenance of the airplane by the pilot in command.NTSB BFO91LA044Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · New Castle, DEThe pilot's failure to maintain directional control during the takeoff roll. Contributing to the accident was the unfavorable wind condition.NTSB NYC91FA115Accident · 2 fatalField investigationFinal reportCessna 172G · New Bedford, MAThe pilot's improper planning/decision and failure to maintain proper altitude after encountering adverse weather at low altitude. The adverse weather (fog) was a related factor.NTSB LAX91LA168Accident · No injuriesLimited investigationFinal reportCessna 140 · El Mirage, CAThat the pilot made a poor inflight decision to practice the slow flight maneuver at a low altitude and that he failed to maintain airspeed.NTSB CHI91LA128Accident · No injuriesLimited investigationFinal reportDe Havilland Beaver U-6A · Oak Island, MNUnsuitable terrain was selected by the pilot. A factor related to the accident was the terrain/runway was composed of weak ice.NTSB CHI91FA126Accident · 2 fatalField investigationFinal reportBeech F.33A · Chippewa Falls, WIThe first pilot's continued flight in known adverse weather. Factors in the accident were the first pilot's poor weather evaluation, the second pilot's complacency and the first pilot's self induced pressure to complete a checkout in model.NTSB BFO91LA043Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Morehead, KYThe pilot's operation of his aircraft in exceedingly high wind conditions.NTSB ANC91LA051Accident · Serious injuriesLimited investigationFinal reportAeronca 11AC · Kahiltna Glac., AKA downdraft and the pilot's inadequate remedial action.NTSB ANC91IA052Incident · No injuriesIncident investigationFinal reportPiper PA-32-301 · Eek, AKThe failure of the center torque link bolt.NTSB ANC91FA050Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Tatitlek, AKFailure of both pilots to see-and-avoid each other (inadequate visual lookout). A factor related to the accident was: inadequate communication among all participating aircrews.NTSB MIA91LA119Accident · No injuriesLimited investigationFinal reportCessna 150L · Palm Bay, FLLoss of control during the landing roll due to failure of the pilot to apply aileron control to prevent the airplane from drifting off the runway due to a crosswind and failure to maintain directional control. Contributing to the accident was the pilot's lack…NTSB LAX91LA166Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Carefree, AZInadequate supervision by the certified flight instructor (CFI), an inadequate visual lookout by both pilots.NTSB LAX91LA165Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Hemet, CAThe failure of the PIC to select a proper touch down point. Contributing to the accident was the lack of recent familiarity with the geographic layout of the landing area.NTSB LAX91LA164Accident · Serious injuriesLimited investigationFinal reportPiper PA 46 · North Hollywood, CAThe pilot-in-command's poor preflight planning, inadequate fuel consumption calculations which resulted in a loss of engine power due to fuel exhaustion, and the pilot-in-command's failure to follow air traffic control verbal instructions which would have…NTSB ATL91LA078Accident · 1 fatalLimited investigationFinal reportLewis Challenger II · Thomaston, GAThe pilot's failure to properly maintain the airplane in accordance with prescribed procedures which resulted in fuel contamination, fouled spark plugs, and a loss of engine power. The pilot also failed to follow normal emergency procedures for the loss of…NTSB NYC91LA110Accident · No injuriesLimited investigationFinal reportCessna 182F · Carrabassett Vy, MEImproper use of the carburetor heat by the pilot which resulted in a power loss due to carburetor ice over unsuitable terrain.NTSB NYC91LA109Accident · No injuriesLimited investigationFinal reportCessna 150E · Walkill, NYAn inflight collision with terrain during an uncontrolled descent after the pilot parachuted from the airplane. Contributing to the accident were fuel exhaustion and the pilot's disregard for emergency procedures.NTSB NYC91LA108Accident · No injuriesLimited investigationFinal reportCessna 402A · Albany, NYA collapse of the nose gear due to a failure of the nose gear trunion.NTSB NYC91LA105Accident · No injuriesLimited investigationFinal reportCessna 170B · Newburyport, MAThe pilot failing to compensate adequately for adverse wind conditions during takeoff.NTSB NYC91LA104Accident · Minor injuriesLimited investigationFinal reportPiper J-4A · Mahopac, NYThe erratic performance of the left magneto resulting in inadequate climb capabilities and in flight collision with terrain.NTSB NYC91FA103Accident · 1 fatalField investigationFinal reportBellanca 17-31 ATC · Gt. Barrington, MAThe mechanic's improper use of anti-seize compound on the injector nozzle threads which resulted in an engine failure.NTSB MIA91LA118Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Green Cove Spgs, FLLoss of control while on approach to land due to failure of the pilot to maintain vs resulting in the airplane stalling and impacting the ground nose low.NTSB LAX91LA231Accident · No injuriesLimited investigationFinal reportSchleicher ASW-20 · Julian, CAThe pilot's failure to maintain control of his experimental glider during takeoff. A contributing factor was the pilot's encounter with gusty winds.NTSB LAX91LA163Accident · Minor injuriesLimited investigationFinal reportSchempp-Hirth Ventus B/16.6 · Lake Cobb, CAThat the pilot's visual lookout was improper. Contributing to this accident was the unmarked transmission wire.NTSB LAX91LA162Accident · No injuriesLimited investigationFinal reportHughes 369D · Yerington, NVThe pilot's excessive airspeed and rate of descent on final approach to land, and subsequent loss of rotor RPM while attempting to flare. The ditch was a related factor.NTSB LAX91LA161Accident · Minor injuriesLimited investigationFinal reportRockwell 112TCA · Burbank, CAThat the pilot failed to properly preflight the airplane and miscalculated the airplane's fuel consumption. Contributing to this accident was fuel exhaustion.NTSB CHI91LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · Oskosh, WIRefueling not performed resulting in loss of engine power due to fuel exhaustion. Factors related to the accident were misjudged fuel consumption calculations and non suitable terrain.NTSB BFO91LA041Accident · No injuriesLimited investigationFinal reportCessna 172P · College Park, MDThe pilot misjudged altitude and distance which resulted in an overrun of the runway.NTSB ATL91LA082Accident · No injuriesLimited investigationFinal reportCessna 172P · Hatteras, NCThe pilot's improper landing flare, subsequent inadvertent porpoise, and his failure to execute a bounced landing recovery.NTSB ATL91FA077Accident · 1 fatalField investigationFinal reportCessna 172D · Mocksville, NCThe loss of engine power due to open circuits in the ignition wiring harness, and the pilot's failure to maintain flying airspeed during the forced landing attempt. Factors in this accident were the dark night lighting conditions at the time of the accident.NTSB SEA91LA079Accident · No injuriesLimited investigationFinal reportGrumman American AA-1C · Wenatchee, WACarburetor ice as a result of the pilot's improper use of carburetor heat.NTSB SEA91LA078Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Kent, WAThe pilot's inadequate remedial action to correct the imminent dynamic rollover. Factors to the accident were: the pilot's poorly planned approach and lack of totoal flight experience.NTSB NYC91LA116Accident · No injuriesLimited investigationFinal reportPiper 180 · Andes, NYThe failure of the pilot to maintain directional control during a landing with unfavorable winds.NTSB NYC91LA107Accident · Serious injuriesLimited investigationFinal reportEnstrom F28A · Leetonia, OHThe helicopter hover performance was exceeded by the pilot and his failure to perform a normal approach to a landing. Factors were the high winds and the tailwind condition.NTSB NYC91LA106Accident · No injuriesLimited investigationFinal reportCessna 172P · Burlington, CTThe failure of the pilot to maintain directional control during the landing. Factors related to the accident were: improper use of the flight controls by the pilot, his lack of recent experience and total time, and the crosswind.NTSB NYC91LA102Accident · 1 fatalLimited investigationFinal reportSchweizer SGS-1-30 · Wurtsboro, NYAn inflight failure of the left wing spar due to overload from pilot induced control inputs, while recovering from a dive. Factors related to the accident were, the pilot's decision to fly with the trim system disconnected and lack of recent experience in…NTSB LAX91LA167Accident · No injuriesLimited investigationFinal reportCessna 414A · Avenal, CAThe failure of the pilot to maintain directional control after striking a dirt berm during the landing roll. Contributing to the accident was the failure of the pilot to ensure that the airport was adequate for his intended operations.NTSB LAX91LA160Accident · No injuriesLimited investigationFinal reportBurnett, Jerry D. Challenger II · Bullhead City, AZThe disintegration of the propeller. Contributing to this accident was the deterioration of aircraft control and the nonavilability of suitable landing terrain.NTSB FTW91LA062Accident · No injuriesLimited investigationFinal reportCessna A188B · Tipton, OKFailure of the pilot to maintain poroper clearance above obstacles. A factor was the sun glare.NTSB FTW91LA061Accident · Serious injuriesLimited investigationFinal reportCessna 150D · San Ygnacio, TXPower loss due to carburetor ice and a malfunctioning carburetor heat control and the pilot's loss of control of the airplane.NTSB DEN91LA059Accident · No injuriesLimited investigationFinal reportBeech A36 · Salida, COThe dual student's poor takeoff technique, his failure to maintain directional control, and inadequate supervision by the PIC CFI. A factor was: the dual student's lack of experience in mountain flying.