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 SEA92LA054Accident · Serious injuriesLimited investigationFinal reportMichael Conner Avid Flyer · Nampa, IDThe pilot's inadequate weather evaluation. A factor in the accident was the unfavorable wind.NTSB LAX92LA134Accident · No injuriesLimited investigationFinal reportBell 206BIII · Glenbrook, NVFailure of the pilot-in-command to follow the helicopter's performance data while translating out of translational lift to and out of ground effect.NTSB FTW92LA078Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Gillette, ARThe unsuitable terrain selected by the pilot.NTSB DEN92LA039Accident · No injuriesLimited investigationFinal reportBeech 55 · Longmont, COThe student pilot's failure to maintain directional control and the flight instructor's inadequate supervision.NTSB ATL92FA053Accident · 2 fatalField investigationFinal reportCessna 172P · N Topsail Beach, NCThe failure of the pilot to obtain and/or maintain adequate airspeed during takeoff, which resulted in an inadvertent stall and collision with the ground. Factors were: the failure of the pilot to follow procedures/directives, his operation of the aircraft…NTSB NYC92LA070Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Medina, OHThe pilot's failure to maintain control of the airplane during landing. Contributing to the accident were strong winds.NTSB MIA92LA180Accident · Serious injuriesLimited investigationFinal reportD.W. Owens Stitts SA3B · Winter Haven, FLFuel contamination and unsuitable terrain encountered while the pilot was attempting an emergency landing on the airport property.NTSB MIA92IA090Incident · No injuriesIncident investigationFinal reportCessna 402C · Fort Lauderdale, FLImproper overhaul by company maintenance personnel and inaccurate gear down and locked indication in the cockpit.NTSB LAX92LA133Accident · Minor injuriesLimited investigationFinal reportHelio HST-550A · Salome, AZThe pilot's inadequate in-flight planning, improper altitude, and delaying the required remedial action to prevent the collision with the mountain. Contributing to the accident was the unfavorable wind and downdraft conditions.NTSB LAX92AMS03Accident · 2 fatalFinal reportCessna 172D · Pacific Ocean (Pacific Ocean)The failure of the pilot to adequately evaluate the weather conditions, and continued VFR flight into IMC conditions which resulted in the pilot becoming lost and disoriented. Contributing to the accident was the lack of total aeronautical experience and fuel…NTSB FTW92LA079Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Boerne, TXThe pilot in command inadvertently stalling the aircraft. Factors were the pilot not maintaining proper altitude during the approach and his abrupt aircraft handling.NTSB DEN92LA038Accident · No injuriesLimited investigationFinal reportThorpe T-18 · Albuquerque, NMA failure of the rudder control system when the pilot attempted to correct for an inadvertent ground loop during landing roll.NTSB ATL92LA055Accident · No injuriesLimited investigationFinal reportPitts S-1 · Reidsville, NCThe pilot's failure to compensate for the tailwind and the improper touch down point. Factors were the tailwind and downdraft which resulted from the tall obstacles (trees) around the runway.NTSB ATL92LA052Accident · No injuriesLimited investigationFinal reportMooney M20C · Charleston, SCThe blocked fuel vent.NTSB ATL92LA051Accident · No injuriesLimited investigationFinal reportCessna 172I · Bainbridge, GAThe pilot's failure to maintain airspeed on the initial climbout, and the inadvertent stall/mush which resulted. Factors in this accident were: the high obstructions (trees) near the airstrip.NTSB LAX92LA132Accident · Minor injuriesLimited investigationFinal reportCessna 195A · San Jose, CAThe pilot's improper compensation for the existing wind conditions and improper recovery from a bounced landing. Contributing to the accident was the left quartering tail/crosswind.NTSB LAX92LA131Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Vernalis, CAThe operator's failure to properly comply with an airworthiness directive affecting the second-stage turbine wheel assembly. Contributing to this accident was the uncontained failure of the second-stage turbine wheel and the rough/uneven terrain.NTSB LAX92FA130Accident · 2 fatalField investigationFinal reportCessna 150M · San Ysidro, CAThe certified flight instructor's improper supervision of the flight to correct the student pilot's improper use of the flight controls resulting in an excessive angle of attack and failure to maintain the proper airspeed. Contributing to this accident was…NTSB FTW92LA096Accident · Minor injuriesLimited investigationFinal reportBurnett Teenie II · Edmond, OKPartial engine power loss due to cylinder failure. A factor was the lack of suitable terrain for the forced landing.NTSB FTW92LA076Accident · Minor injuriesLimited investigationFinal reportAvions Fairey T-66 · Mineral Wells, TXFuel starvation due to a contaminated fuel filter. A factor was the soft terrain.NTSB FTW92FA077Accident · 1 fatalField investigationFinal reportBell 212 · Morgan City, LAThe inflight separation of the main rotor system as results of the main rotor static stop contacting the mast for undetermined reasons.NTSB DEN92LA036Accident · No injuriesLimited investigationFinal reportEnstrom TH-28 · Leadville, COThe pilot misjudging the descent rate and consequently delaying the flare. A factor was: downdraft.NTSB ANC92LA042Accident · No injuriesLimited investigationFinal reportPiper PA-18A-135 · Paxson, AKThe pilot failed to attain & maintain takeoff airspeed. Factors to the accident were: takeoff was performed with a tailwind, and inadequate remedial action.NTSB NYC92LA068Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Williamstown, NJImproper bounced landing recovery by the pilot which resulted in a loss of control and the airplane striking a parked airplane.NTSB MIA92LA089Accident · No injuriesLimited investigationFinal reportCessna 152 · Michigan City, MSPartial loss of engine power due to undetermined reasons.NTSB CHI92LA100Accident · No injuriesLimited investigationFinal reportCessna 340 · Ashland, WIThe pilot delayed initiating a go-around. Factors were icing conditions and inadequate windshield anti-ice which resulted in restricted visual lookout.NTSB CHI92LA099Accident · No injuriesLimited investigationFinal reportCessna 172 · Manhattan, KSThe pilot's failure to refuel the airplane. A factor related to the accident was the rough terrain on which the landing was made.NTSB CHI92LA093Accident · No injuriesLimited investigationFinal reportCessna 182B · Auburn, INThe improper maintenance and adjustment of the carburetor by other maintenance personnel.NTSB ANC92LA045Accident · No injuriesLimited investigationFinal reportCessna 207A · Quinhagak, AKThe total loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain on which to make the forced landing.NTSB SEA92LA052Accident · No injuriesLimited investigationFinal reportCessna 150L · Mulino, ORCarburetor ice and improper use of the carburetor heat. Factors to the accident were: carburetor icing conditions and an inadequate weather evaluation.NTSB FTW92LA074Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Mc Alester, OKInadvertent stall. A factor was a total power loss due to fuel exhaustion.NTSB ATL92LA050Accident · No injuriesLimited investigationFinal reportCessna 152 · Knightdale, NCThe student pilot's failure to maintain directional control of the airplane during the landing roll. Factor(s) in this accident were: the crosswind conditions prevailing at the airport, and the soft, muddy terrain conditions adjacent to the runway.NTSB LAX92LA129Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Woodland, CAThe company maintenance personnel's inadequate 100-hour inspection and failure to replace the oil line. Contributing to the accident was the rupture of the oil line and the ditch that traversed the emergency landing area.NTSB LAX92GA128Accident · 2 fatalFinal reportCessna T210N · Lake Hughes, CAPoor maintenance repair and annual inspection by the company's maintenance personnel and the pilot-in-command's misjudging altitude. Contributing to this accident was the pilot-in-command intentional stall, improper emergency procedure, selection of…NTSB FTW92LA075Accident · No injuriesLimited investigationFinal reportBell 206B III · Grand IsleHeavy sea state due to the high winds. A factor was the power loss.NTSB ATL92FA049Accident · 1 fatalField investigationFinal reportBeech H-18 · Morganton, NCThe failure of the pilot to follow FAR and company procedures, and his failure to maintain proper altitude during the approach. Factors were the mountainous terrain conditions, and the foggy, low ceiling weather conditions existing at the time of the accident.NTSB NYC92FA067Accident · 1 fatalField investigationFinal reportCessna 310K · Unionville, PAThe pilot did not follow the published IFR procedures and allowed the airplane to descend to an altitude insufficient to clear the terrain. Factors which contributed to the accident were: the pilot's apprehension due to the low fuel state, the dark night,…NTSB LAX92LA127Accident · Serious injuriesLimited investigationFinal reportBellanca 7ECA · Apple Valley, CAThe pilot's failure to maintain airspeed and inadvertent stall. Contributing to this accident was engine fuel exhaustion for undetermined reasons.NTSB LAX92LA126Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Dixon, CAThe pilot's premature lift-off. Contributing to the accident was the inadvertent stall/mush and the soft dirt airstrip.NTSB ANC92LA041Accident · Minor injuriesLimited investigationFinal reportDe Havilland DH6 · Anchorage, AKInadequate visual look out by both pilots in the airplane, and the driver of the ground vehicle. Contributing factors to the accident were the absence of side conspicuity lighting on the ground vehicle, and the night lighting conditions.NTSB SEA92LA053Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Quilcene, WAThe pilot's failure to maintain directional control. Factors include a poor in flight decision and unfavorable/gusty winds.NTSB SEA92LA051Accident · No injuriesLimited investigationFinal reportBeech A36TC · Salt Lake City, UTThe pilot's inadvertent activation of the fuel boost pump. Factors to the accident were: poor aircraft preflight. Diverted attention, and inadequate remedial action.NTSB NYC92LA066Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-12D · Gibson Island, MDThe pilot's failure to maintain proper altitude and clearance with water, which resulted in an in flight collision with water. Contributing to the accident was the pilot allowed the airplane to descend while making a right turn.NTSB NYC92LA065Accident · Minor injuriesLimited investigationFinal reportCessna 305A · Plymouth, MAThe failure of the pilot to use carburetor heat which resulted in the formation of carburetor ice and a subsequent loss of engine power and forced landing in trees.NTSB LAX92LA365Accident · 2 fatalLimited investigationFinal reportChristen Industries Eagle II · Point Reyes Stn, CAImproper preflight planning by the pilot in command by exceeding the airplane's maximum acrobatic gross weight and exceeding the aft aerobatic center of gravity limit. Contributing to the accident was the pilot's decision to perform acrobatic maneuvers which…NTSB LAX92LA125Accident · No injuriesLimited investigationFinal reportCessna 182N · San Ardo, CAThe pilot's inadequate preflight inspection. Contributing to this accident was water contamination in the fuel and the soft soil landing area.NTSB LAX92LA124Accident · Minor injuriesLimited investigationFinal reportCessna 150 · San Jose, CAThat the certified flight instructor's (CFI) misjudged approach which resulted in a long landing, the cfi's in-flight decision to a go-around with partial power, and the failure of the CFI to maintain aircraft control in the initial climb segment of the…NTSB FTW92LA072Accident · Serious injuriesLimited investigationFinal reportRyan Navion A · Oklahoma City, OKThe propeller hydraulic control pitch setting being incorrect for undetermined reasons. A factor in the accident was the pilot's failure to identify and correct the pitch setting as the propeller went to a higher setting.NTSB DEN92LA037Accident · No injuriesLimited investigationFinal reportCessna 177RG · Durango, COA total loss of power due to a mechanical failure of the engine. Factors were: rough and uneven snow covered terrain.NTSB CHI92LA098Accident · No injuriesLimited investigationFinal reportCessna 150L · Peru, ILThe students pilot's inadequate compensation for wind conditions. A factor in the accident was the pilot's lack of experience in the type of operation.