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 DEN05CA147Accident · No injuriesData collectionFinal reportCessna T210L · Las Animas, COthe loss of engine power due to fuel exhaustion. Contributing factors were the pilot's inadequate preflight planning and lack of suitable terrain for the forced landing.NTSB CHI05FA274Accident · 3 fatalField investigationFinal reportRobinson R44 · Drummond, WIClearance not obtained/maintained by the pilot during an unknown phase of flight. Contributing factors were the improper use of procedures by the pilot, the inadequate surveillance of the operation by company/management, and the wire.NTSB NYC05CA146Accident · No injuriesData collectionFinal reportCessna 172P · Mitchellville, MDThe pilot's failure to maintain directional control during landing.NTSB MIA05CA160Accident · No injuriesData collectionFinal reportBell 206B3 · Titusville, FLThe flight instructor's improper flare resulting in a hard landing and main rotor contact with tail boom.NTSB LAX05LA315Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Fall River Mill, CAthe pilot's inadequate compensation for the crosswind condition and failure to maintain runway alignment during landing.NTSB LAX05CA314Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Kamuela, HIThe student's misjudged landing flare, and the instructor's inadequate supervision and delayed remedial action. A factor in the accident was the high density altitude.NTSB IAD05CA140Accident · No injuriesData collectionFinal reportBeech BE-36 · Farmingdale, NYThe pilot's improper recovery from a bounced landing.NTSB CHI05FA272Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-36 · West Memphis, ARThe pilot's improper in-flight decision not to land at the departure runway or other available airports during the emergency descent, and his failure to maintain clearance from a vehicle and terrain. Contributing factors were a false engine fire warning…NTSB SEA05CA197Accident · No injuriesData collectionFinal reportCessna 180H · Yelm, WAThe mixture control linkage separation as a result of a missing retaining nut and washer on the mixture cable attach bolt. Inadequate maintenance inspection and fences were factors.NTSB NYC05LA145Accident · No injuriesLimited investigationFinal reportEurocopter Deutschland BK-117-B2 · Columbus, OHThe pilot's failure to maintain aircraft control during the landing flare, which resulted in a hard landing. A factor associated with this accident was a tailwind.NTSB LAX05IA312Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320 · Los Angeles, CAThe fatigue failure of two anti-rotation lugs due to repeated cyclic pre-landing tests, which allowed the nosewheels to deviate from the 0-degree position on landing gear retraction. A contributing factor was the design of the Brake Steering Control Unit…NTSB LAX05CA313Accident · No injuriesData collectionFinal reportHiller UH 12-E · Five Points, CAThe pilot's failure to refuel the helicopter, which resulted in fuel exhaustion.NTSB DFW05CA248Accident · No injuriesData collectionFinal reportPiper PA-46T · El Reno, OKThe improper flare which resulted in a hard landing. A related factor was the instructor's delayed remedial action.NTSB DFW05CA247Accident · Minor injuriesData collectionFinal reportSmith, Ted Aerostar 601P · Mexia, TXThe pilot's failure to maintain clearance from the barn. Contributing factors were the pilot's inadequate preflight planning/preparation and the high-density altitude.NTSB CHI05IA273Incident · No injuriesIncident investigationFinal reportConvair Div. of Gen. Dynamics 440 · Kenosha, WIThe flight crew failed to verify that the cargo was secured before takeoff.NTSB ANC05LA149Accident · Serious injuriesLimited investigationFinal reportChampion 7EC · Wasilla, AKThe pilot's failure to maintain adequate airspeed while maneuvering over wildlife, which resulted in an uncontrolled descent and subsequent collision with trees. A factor contributing to the accident was an inadvertent stall.NTSB SEA05LA198Accident · 1 fatalLimited investigationFinal reportCessna 170A · Ione, WAThe pilot's failure during low-level maneuvering flight, to maintain clearance from a pair of unmarked power lines. Factors include the pilot's intentional low altitude flight/maneuver and wires.NTSB LAX05WA316Accident · 2 fatalForeign investigationRobinson R-22 Mariner · Falaise, FranceNTSB LAX05TA306Accident · No injuriesFinal reportBell 407 · Inyokern, CAThe pilot failed to maintain tail rotor clearance from obstacles during landing.NTSB LAX05LA309Accident · Serious injuriesLimited investigationFinal reportThomas RV4 · Kernville, CAa loss of engine power due to fuel starvation caused by the pilot's failure to select a tank containing fuel for takeoff. A factor in the accident was the lack of a runway overrun area beyond the departure end of the runway.NTSB LAX05LA308Accident · Serious injuriesLimited investigationFinal reportEurocopter AS350B3 · Running Springs, CAThe pilot's failure to maintain an adequate clearance from trees while performing long line external lift operations.NTSB DFW05WA245Accident · 9 fatalForeign investigationBell 412EP · Llano Grande, MexicoNTSB DFW05FA244Accident · 2 fatalField investigationFinal reportDiamond Aircraft Industries DA20-C1 · Pleasanton, TXThe flight instructor's failure to maintain clearance from an unmarked transmission line. A contributing factor was the low altitude flight.NTSB DFW05CA250Accident · No injuriesData collectionFinal reportRobinson R44 · Batesville, TXThe pilot's failure to maintain rotor rpm and his subsequent encounter with settling with power.NTSB CHI05CA224Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Mount Ayr, IAThe pilot's selection of a wrong runway, and the misjudged distance/speed which resulted in an overrun. Contributing factors were the tailwind, and the ditch.NTSB NYC05LA144Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Millville, NJThe flight instructor's improper in-flight decision to perform a emergency landing to a runway, with a tailwind, and his failure to maintain airspeed after aborting that landing, which resulted in an inadvertent stall and subsequent impact with terrain.…NTSB LAX05FA311Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Baker, CAThe pilot's continued VFR flight into adverse weather conditions that resulted in a collision with mountainous terrain. Contributing to the accident was the obscuration of mountainous terrain by rain and low clouds, moderate turbulence, and the pilot's…NTSB LAX05CA310Accident · Minor injuriesData collectionFinal reportClark Vans RV8 · Sonoma, CAa loss of engine power due to the failure of the master electrical power switch, which removed power to the electronic ignition.NTSB DFW05CA246Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Guion, ARThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN05CA145Accident · No injuriesData collectionFinal reportCessna 172S · Cedar City, UTthe student pilot's failure to maintain aircraft control during the landing. Factors contributing to the accident were the improper flare and improper recovery from a bounced landing.NTSB NYC05CA143Accident · No injuriesData collectionFinal reportCessna 172P · Caldwell, NJThe student pilot's failure to maintain directional control while landing. A factor in this accident was the crosswind condition.NTSB LAX05LA305Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Bisbee, AZthe pilot's failure to lean the mixture in accordance with the pilot operating handbook specified procedures, which resulted in a power deficiency, a degraded climb capability, and the inability to attain/maintain an adequate airspeed that led to a stall/mush…NTSB LAX05LA303Accident · Minor injuriesLimited investigationFinal reportNorth American Navion A · Chowchilla, CAthe loss of engine power for undetermined reasons.NTSB IAD05LA139Accident · No injuriesLimited investigationFinal reportHart None · Broadalbin, NYA loss of engine power for undetermined reasons.NTSB DEN05LA143Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Torrington, WYfailure of the #7 connecting rod, causing engine seizure. A contributing factor was the berm.NTSB DEN05CA146Accident · No injuriesData collectionFinal reportSchleicher ASW-20B · Moriarty, NMthe pilot's failure to maintain control of the glider during the takeoff roll which resulted in a ground loop.NTSB CHI06CA018Accident · No injuriesData collectionFinal reportStinson 108-1 · Tea, SDThe pilot's failure to maintain directional control during the landing rollout which resulted in the encountered ground loop.NTSB SEA05LA196Accident · No injuriesLimited investigationFinal reportCessna 152 · Olympia, WAThe pilot's loss of aircraft control during landing roll, and airplane's subsequent inadvertent ground loop.NTSB SEA05CA195Accident · Minor injuriesData collectionFinal reportEiland RAF-200 Gyro · Bend, ORThe malfunction of the flight controls for an undetermined reason, which resulted in a loss of control and in-flight collision with terrain.NTSB LAX05CA302Accident · No injuriesData collectionFinal reportCessna 172S · Show Low, AZthe pilot's selection of a downwind runway for landing and his inadequate compensation for the strong and gusty quartering tail wind conditions, which resulted in a tail strike during landing.NTSB IAD05LA137Accident · 1 fatalLimited investigationFinal reportPiper PA-24-260 · Tiffin, OHThe pilot's decision to takeoff in weather below the published takeoff minimums, which resulted in spatial disorientation and the airplane's collision with trees and terrain. Factors in the accident were the instrument meteorological conditions, and the…NTSB DFW05FA242Accident · 1 fatalField investigationFinal reportAkro Tech Aviation Inc. Giles G-300 · Yukon, OKThe catastrophic separation of the canopy as result of the failure of the forward canopy hinge while performing aerobatics and the subsequent incapacitation of the pilot.NTSB DFW05FA241Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Houston, TXThe pilot's improper in-flight decision to maneuver back to the departure airport following a loss of engine power on initial climb. Contributing factors were the loss of engine power for undetermined reasons, and the dark night conditions.NTSB DEN05LA142Accident · Serious injuriesLimited investigationFinal reportShea Vans RV6A · Glendo, WYfailure of the nose gear during the landing roll.NTSB DCA05MA099Accident · No injuriesMajor investigationFinal reportAirbus A321-231 · Fort Lauderdale, FLFollowing a bounced landing, the pilot in command activated his sidestick controller while the first officer was in control of the airplane, which subsequently resulted in the overcontrol of pitch and a tailstrike. Contributing to the circumstances of this…NTSB CHI05CA270Accident · No injuriesData collectionFinal reportCessna 182S · Waukesha, WIThe misjudged flare by the pilot.NTSB LAX05CA301Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Petaluma, CAa loss of engine power due to fuel exhaustion.NTSB DEN05LA148Accident · 1 fatalLimited investigationFinal reportBrown Hi-MAX 1700R · Fort Morgan, COThe pilot's failure to maintain control of the airplane during a forced landing. Contributing factors were the resultant and inadvertent stall, the loss of engine power for undetermined reasons, and the pilot's lack of familiarity with the airplane.NTSB ANC05CA148Accident · No injuriesData collectionFinal reportAeronca 7AC · Coldfoot, AKThe pilot's misjudgment of distance/altitude during the landing flare/touchdown, which resulted in an undershoot and subsequent nosing down of the airplane when the main landing gear tires contacted shallow water prior to the intended landing site.NTSB ANC05CA147Accident · No injuriesData collectionFinal reportCessna 172 · Anchorage, AKThe pilot's misjudgment of distance/speed during landing, which resulted in an overrun, a loss of directional control, and a nose over during the landing roll.