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 ATL92LA034Accident · 1 fatalLimited investigationFinal reportCessna 177B · Memphis, TNThe passenger's failure to follow proper procedures to walk behind the airplane. Factors were the dawn light conditions and the light rain.NTSB ANC92LA027Accident · No injuriesLimited investigationFinal reportCessna 206 · English Bay, AKThe pilot failed to maintain directional control of the airplane during the landing roll. Contributing factors were the ice and slush on the runway, the snowbank, and the crosswind.NTSB FTW92IA055Incident · No injuriesIncident investigationFinal reportBoeing 737-232 · Dfw Airport, TXThe failure of the aft cone bolt as result of preexisting fatigue cracking due to improper maintenance, and the failure of the secondary support structure as a result of loads that exceeded the capacity of the attaching hardware and the crushable honeycomb…NTSB BFO92LA016Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Mount Holly, NJA loss of engine power for undetermined reasons.NTSB MIA92LA056Accident · Minor injuriesLimited investigationFinal reportAero Commander 560E · Boca Raton, FLImproper fuel tank selector position of both engines resulting in total loss of engine power due to fuel starvation. Also, failure of the pilot to perform the emergency procedures following the loss of power from both engines.NTSB LAX92LA083Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Altadena, CAThe pilot's improper use of the fuel selector by selecting an empty tank. Contributing to the accident was the pilot's decision to operate the airplane with a known deficiency without having maintenance performed to determine the cause of a previous loss of…NTSB ANC92LA025Accident · No injuriesLimited investigationFinal reportCessna 180 · Atmautluak, AKThe pilot selected unsuitable terrain. Factors contributing to the accident were the dawn light condition and the snow on the runway.NTSB SEA92LA036Accident · No injuriesLimited investigationFinal reportSchweizer SGS-1-35C · Hood River, ORPoor preflight planning and preparation along with the pilot's restricted visibility. Factors to the accident were: clouds and VFR flight into IMC.NTSB LAX92LA081Accident · No injuriesLimited investigationFinal reportCessna 210 · Bakersfield, CAThe pilot's attempt to restart the engine when there was evidence of a fuel leak. A factor in the accident was the fractured fuel line due to the improper installation and overtorque of the line by company maintenance.NTSB LAX92FA082Accident · 4 fatalField investigationFinal reportCessna 421C · Mammoth Lakes, CAThe failure of the pilot to plan and conduct his departure flight to avoid high mountainous terrain, during which the pilot became lost/disoriented. Contributing to the accident was self induced pressure to depart before the arrival of a snow storm.NTSB CHI92FA067Accident · 1 fatalField investigationFinal reportBeech A-36TC · Pekin, ILThe pilot-in-command's continued flight into icing conditions and his failure to use the airplane's anti-ice/de-ice system resulting in a build-up of ice over the airplane's surface area and resultant loss of control. Factors which contributed to the accident…NTSB CHI92DCJ01Accident · 2 fatalFinal reportPiper PA-18-125 · Ashby, NEThe pilot's failure to maintain aircraft control while maneuvering.NTSB BFO92LA021Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Edgartown, MAFailure of the pilot to attain adequate airspeed, which resulted in a stall. Factors related to the accident were the crosswind, the pilot's inadequate compensation for the wind and failure to maintain proper alignment with the runway, and high obstructions.NTSB SEA92LA035Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Newberg, ORA poorly planned final approach. Factors in the accident were: proper glidepath was not maintained and inadequate remedial action.NTSB MIA92LA054Accident · 1 fatalLimited investigationFinal reportSmith/Davis DA-2A · Holly Springs, MSThe pilot-in-command's improper management of fuel. This resulted in the airplane experiencing fuel exhaustion, forced landing, and in flight collision with terrain.NTSB LAX92LA080Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Fresno, CAThe improper major repair of the carburetor heat control by unidentified persons that resulted the failure of the air intake distribution system and the loss of engine power.NTSB LAX92LA079Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Young, AZThe failure of the pilot to maintain directional control during the landing roll. Contributing to the accident was the soft muddy runway conditions at the dirt airstrip.NTSB FTW92LA054Accident · 2 fatalLimited investigationFinal reportAlvin D. Campbell KR-2 · San Marcos, TXThe modification of the canopy hinge system which resulted in the loss of aircraft control due to an inflight canopy separation.NTSB DEN92LA023Accident · No injuriesLimited investigationFinal reportCessna 152 · Falcon, COEngine failure over unsuitable terrain due to fuel exhaustion. Factors were: pilot inexperience and becoming lost and disoriented.NTSB DEN92FA024Accident · 3 fatalField investigationFinal reportCessna 421B · Steamboat Spgs, COAirframe ice and the pilot's failure to remove it. Factors were: aircraft weight exceeded and lack of pilot certification.NTSB BFO92LA015Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Wadsworth, OHFailure of the pilot to attain an adequate airspeed during an attempted go around, which resulted in a stall. His premature raising of the flaps and lack of experience in the make and model of aircraft were related factors.NTSB LAX92FA078Accident · 2 fatalField investigationFinal reportCessna 182R · Flagstaff, AZThe pilot became spatially disoriented and lost control of the airplane as he turned away from ground lights toward unlighted terrain. The clouds, fog, and dark night condition were factors.NTSB FTW92LA053Accident · No injuriesLimited investigationFinal reportBeech B19 · Bonham, TXInadvertent stall during the forced landing approach. A factor was the partial loss of power for undetermined reasons.NTSB DEN92IA025Incident · No injuriesIncident investigationFinal reportBoeing 737-300 · Denver, COAn electrical short circuit in a main wire bundle due to chafing of the bundle on airframe structural members.NTSB DCA92MA016Accident · 2 fatalMajor investigationFinal reportBeech 1900C · Gabriels, NYFailure of the captain to establish a stabilized approach, his inadequate cross-check of instruments, his descent below specified minimum altitude at the final approach fix, and failure of the copilot to monitor the approach. Factors related to the accident…NTSB SEA92LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Logan, UTDirectional control was not maintained. A factor to the accident was: the pilot's lack of total flight experience.NTSB MIA92LA055Accident · No injuriesLimited investigationFinal reportCessna 182Q · Eustis, FLThe pilot misjudged altitude and distance resulting in undershooting the landing. Contributing to the acident was the dark night condition.NTSB CHI92FA066Accident · 1 fatalField investigationFinal reportPiper PA-31P · Mosinee, WIAn inflight fire with the cabin heater as the origin, and unsuitable terrain in which to make a forced landing. A factor related to the accident was the soft terrain.NTSB BFO92LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Glasgow, KYDeer on the runway. Other related factor ws a dark night.NTSB ANC92LA060Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-2 · Port Walter, AKThe design stress limits of the airplane were exceeded. A factor to the accident was: rough water.NTSB ANC92LA024Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Nome, AKThe pilot inadvertently stalled the airplane. Contributing to the accident was inadequate altitude.NTSB LAX92LA076Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Lodi, CAThe pilot's improper use of the carburetor heat control and delay in flaring the helicopter for an autorotative touchdown. Carburetor icing conditions and the soft terrain were contributing factors in the accident.NTSB LAX92LA075Accident · No injuriesLimited investigationFinal reportPiper PA601P · San Diego, CAThe pilot's poorly planned approach and delay in accomplishing the proper remedial action while executing a night short field landing at an adequately lighted airport. Contributing to the accident was the failure of the pilot to maintain the proper glide…NTSB LAX92LA074Accident · Minor injuriesLimited investigationFinal reportPiper PA32RT-300 · Big Bear City, CAThe failure of the pilot to maintain directional control and improper use of the rudder. Contributing to the accident was the improper installation by the company of a hand control mechanism that required the pilot to operate the airplane controls with one…NTSB FTW92LA052Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Cottonport, LAThe pilot's failure to compensate for wind conditions. A factor was the crosswind.NTSB CHI92LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Greencastle, INThe worn centering locking lug on the nose gear assembly.NTSB CHI92LA064Accident · Serious injuriesLimited investigationFinal reportCessna 182K · Huntington, INPilot factor in that he failed to maintain flying speed in a turn which resulted in an inadvertent stall. Factors related to the accident are; icing conditions, hazardous weather advisory disregarded, flight into known adverse weather, and overconfidence in…NTSB FTW92LA051Accident · No injuriesLimited investigationFinal reportCessna 180K · Orange, TXThe ruptured left main gear tire for undetermined reasons.NTSB BFO92FA013Accident · 2 fatalField investigationFinal reportPiper PA-60-601P · North Salem, NYA loss of control due to a distraction caused by a partial loss of power. Contributing to the accident was adverse weather near the destination airport.NTSB ATL92FA032Accident · Serious injuriesField investigationFinal reportPiper PA 28-140 · Blythe, GAThe pilot's failure to apply carburetor heat during the before takeoff check as part of the ground check. A factor was weather conditions favorable for the formation of carburetor ice.NTSB NYC92FA053Accident · 3 fatalClass 1 · FieldFinal reportBeech 1900C · Block Island, RIThe instructor pilot's loss of altitude awareness and possible spatial disorientation, which resulted in the loss of control of the airplane at an altitude too low for recovery; and company management's lack of involvement in and oversight of its Beechcraft…NTSB FTW92LA050Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Tyler, TXThe pilot's failure to feather the propeller and maintain directional control. Factors were the lose of power on one engine for undetermined reasons and the soft terrain.NTSB DEN92LA022Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Glenwood, NMPartial failure of the spark plugs. Factors were inadequate annual inspection and unsuitable mountainous terrain.NTSB DCA92RA015Accident · No injuriesForeign investigationBoeing 747-200F · Taipei, TaiwanNTSB ATL92FA033Accident · 2 fatalField investigationFinal reportBeech C23 · Lineville, ALThe pilot continued VFR into IMC conditions where he collided with trees and terrain. Factors in this accident were: low clouds, obscured terrain, and the pilot's inadequate prelflight planning.NTSB SEA92LA033Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Toledo, WAThe pilot's failure to maintain a proper glidepath.NTSB NYC92FA052Accident · 2 fatalField investigationFinal reportAeronca 7AC · Salisbury, CTThe pilot's failure to maintain airspeed while performing low altitude aerobatic maneuvers, resulting in a stall with insufficient altitude to recover. Factors related to the accident were the pilot's overconfidence in his ability to perform these maneuvers,…NTSB MIA92WA060Accident · No injuriesForeign investigationPiper PA-31-350 · Nagua, Dominican RepublicNTSB MIA92FA053Accident · Serious injuriesField investigationFinal reportCessna 172RG · Melbourne, FLThe flight instructor pilot in command's failure to maintain airspeed while demonstrating a power off approach to the student and his improper retraction of the wing flaps during go around from the approach resulting in an inadvertent stall and inflight loss…NTSB DEN92LA021Accident · Minor injuriesLimited investigationFinal reportCameron V-77 · Littleton, COThe pilot's improper landing procedure, including wrong compensation for wind conditions and improper use of the envelope dump control. A factor was: high wind.