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 LAX06CA286Accident · Serious injuriesData collectionFinal reportAgeton MXL Sport II · Marana, AZThe loss of engine power for undetermined reasons.NTSB CHI06CA276Accident · No injuriesData collectionFinal reportCessna T206H · Cedar Rapids, IAAn in-flight collision with a bird during climb to cruise altitude.NTSB CHI06CA257Accident · No injuriesData collectionFinal reportPiper PA-25-235 · Anamoose, NDThe pilot not maintaining altitude/clearance from terrain during the aerial application pass.NTSB DFW06CA206Accident · No injuriesData collectionFinal reportBeech B200 · Hondo, TXThe collision with an unmarked pothole in the taxiway while taxiing for departure. A contributing factor was the obscuration by water.NTSB DCA06FA068Accident · No injuriesField investigationFinal reportBoeing B757-232 · San Juan, PRthe first officer's inadvertent application of full nose-up trim during a prolonged flare, resulting in an excessive pitch angle during landing and subsequent tailstrike. Contributing to the accident was the flight crew's failure to correct the airplane's…NTSB CHI06FA256Accident · 1 fatalField investigationFinal reportMooney M20J · Smithville, OHThe altitude/ clearance not maintained by the pilot during cruise flight.NTSB SEA06LA175Accident · Serious injuriesLimited investigationFinal reportStraw T-Bird II · Leamington, UTThe pilot's loss of aircraft control (control not possible) due to the failure of the left elevator control surface which was the result of a missing inboard bolt (for undetermined reason) which holds the left elevator bow in place.NTSB NYC06LA216Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Hampton, NHThe pilot's failure to maintain directional control during takeoff.NTSB NYC06FA215Accident · 2 fatalField investigationFinal reportCessna 150G · Penhook, VAThe pilot's failure to maintain aircraft control during climb, which resulted in exceeding the design stress limits of the airplane, and an in-flight breakup. Factors associated with the accident were the pilot's continued visual flight rules flight into…NTSB NYC06CA221Accident · No injuriesData collectionFinal reportCessna 172P · Baltimore, MDThe pilot's improper flare, which resulted in a hard landing.NTSB NYC06CA218Accident · No injuriesData collectionFinal reportBellanca 7GCAA · Farmingdale, NCAn inadequate annual inspection of the airplane, which resulted in a total failure of the elevator cable during flight, and subsequent uncontrolled descent into terrain.NTSB MIA06LA136Accident · No injuriesLimited investigationFinal reportNoakes B J Corby CJ-1 · Edgewater, FLPartial loss of engine power for undetermined reasons.NTSB LAX06TA284Accident · No injuriesFinal reportBell 212 · Happy Camp, CAFailure of compressor second stage stator vane for undetermined reasons while maneuvering.NTSB ANC06LA130Accident · Minor injuriesLimited investigationFinal reportMcNabb Bushmaster · Delta Junction, AKAn electrical short that disabled the electronic ignition system of the airplane's engine during the final approach phase for landing, which resulted in a forced landing and collision with high vegetation. A factor contributing to the accident was the failure…NTSB SEA06CA174Accident · No injuriesData collectionFinal reportCessna 180 · Arock, ORThe pilot's failure to maintain directional control during a go-around, resulting in an in-flight collision with trees and substantial damage to the airplane. Factors included the pilot's failure to attain the proper touchdown point, the delayed go-around,…NTSB MIA06LA135Accident · 2 fatalLimited investigationFinal reportLuscombe 8A · Ocala, FLThe pilot's failure to maintain airspeed during initial climb.NTSB MIA06CA134Accident · Minor injuriesData collectionFinal reportCessna 172N · Pensacola, FLThe student pilot's failure to raise the wing flaps for a go-around resulting in the airplane not climbing and an in-flight collision with trees.NTSB DEN07CA032Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Riverton, WYthe pilot's failure to maintain directional control during the landing roll, resulting in a ground loop.NTSB DEN06WA122Accident · No injuriesForeign investigationCessna C210P · Hoexter, GermanyNTSB DCA06WA070Incident · No injuriesForeign investigationBoeing B737-300 · Doha, QatarNTSB CHI06CA253Accident · No injuriesData collectionFinal reportHedeman Tailwind W8 · Platteville, WIThe loss of engine power as a result of the pilot's inadequate preflight which resulted in a blocked fuel vent that led to fuel starvation.NTSB CHI06CA251Accident · No injuriesData collectionFinal reportLuscombe 8A · Elwell, MIThe airplane nosed over as a result of the pilot's excessive braking after he failed to attain the proper touchdown point and failed to perform a go-around.NTSB ATL06CA125Accident · No injuriesData collectionFinal reportBrown Floyd L Christen Eagle II · Topsail Beach, NCThe in-flight separation of the engine and propeller from the airframe for undetermined reasons, which resulted in the airplane's uncontrolled impact with water.NTSB NYC06LA214Accident · 1 fatalLimited investigationFinal reportCessna 150K · Shelby Gap, KYThe pilot's improper decision to attempt a visual flight rules flight in instrument meteorological conditions, which resulted in an impact with mountainous terrain. A factor was the low ceiling.NTSB LAX06FA283Accident · 3 fatalField investigationFinal reportCessna 337G · Prescott, AZA loss of power in the rear engine for undermined reasons. Contributing to the accident was the pilot's failure to promptly and correctly configure the airplane for single engine flight, and to maintain an adequate airspeed, which resulted in a stall mush.NTSB LAX06CA282Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Auburn, CAthe pilot's failure to comply with weight and balance limitations and failure to attain an adequate airspeed, which resulted in a stall and loss of control.NTSB DFW06FA205Accident · 1 fatalField investigationFinal reportBeech BE95 A-55 · McGregor, TXThe pilot's failure to maintain airspeed resulting in a stall and loss of control of the airplane.NTSB CHI06CA252Accident · No injuriesData collectionFinal reportLet Blanik L-13 · Hampshire, ILThe pilot's inadequate approach for landing and his failure to attain a proper descent rate.NTSB ANC06LA134Accident · No injuriesLimited investigationFinal reportde Havilland DHC-3 · Wainwright, AKThe pilot's failure to adequately compensate for wind conditions during the landing roll, which resulted in a loss of control, and subsequent collision with a ditch when the airplane departed the runway. A factor contributing to the accident was a crosswind.NTSB NYC06IA226Incident · No injuriesIncident investigationFinal reportCessna 206F · Matinicus Islnd, MEAn engine kick back of undetermined origin during engine start.NTSB LAX06CA281Accident · No injuriesData collectionFinal reportCessna 172P · Spanish Springs, NVthe pilot's failure to initiate a timely go-around and to attain an adequate climb rate. Factors in the accident were the high density altitude and the likely quartering tail wind that may have affected the aircraft's climb gradient.NTSB DEN06WA120Accident · 1 fatalForeign investigationBellanca 17-31 ATC · Neuwerk Island, GermanyNTSB DEN06MA119Accident · 1 fatalMajor investigationFinal reportMitsubishi MU-2B-35 · Argyle, FLthe pilot's inadvertent flight into thunderstorm activity that resulted in the loss of control, design limits of the airplane being exceeded and subsequent in-flight breakup. A contributing factor was the failure of air traffic control to use available radar…NTSB ANC06CA128Accident · No injuriesData collectionFinal reportPiper PA-18 · Aniak, AKThe pilot's inadequate compensation for wind conditions during the takeoff initial climb, which resulted in a loss of control and in-flight collision with terrain. A factor contributing to the accident was a windshear.NTSB NYC06CA217Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · White Lake, NYThe flight instructor's failure to ensure the landing gear was retracted prior to attempting a water landing.NTSB MIA06IA133Incident · No injuriesIncident investigationFinal reportBoeing 737-400 · Miami, FLThe pilot's inadvertent application of the left brakes at touchdown. Contributing to the incident was insufficient information in the quick reference handbook on the loss of touchdown protection with an inoperative anti-skid system.NTSB SEA06CA173Accident · No injuriesData collectionFinal reportCessna 182RG · Fairfield, UTThe failure of the pilot-rated-passenger to maintain adequate airspeed on final during a simulated engine-out approach, resulting in the aircraft descending into the terrain about 40 feet short of the runway, and the failure of the pilot-in-command to take…NTSB ANC06LA129Accident · No injuriesLimited investigationFinal reportPiper J5A · North Pole, AKThe pilot's inadequate in-flight planning, which resulted in a loss of engine power due to fuel starvation during cruise flight, and an emergency landing.NTSB ANC06CA127Accident · No injuriesData collectionFinal reportCessna 172 · Healy, AKThe pilot's failure to maintain adequate altitude/clearance while maneuvering, which resulted in an in-flight collision with terrain. Factors associated with the accident were rising terrain, and the pilot's low altitude flight.NTSB ATL06CA124Accident · No injuriesData collectionFinal reportCessna 172R · Winder, GAThe student pilot's failure to maintain control of the airplane during an attempted go-around.NTSB SEA06LA172Accident · No injuriesLimited investigationFinal reportMooney M20C · Eastsound, WAThe pilot's failure to maintain airspeed during final approach resulting in an inadvertent stall and hard landing.NTSB NYC06FA209Accident · 7 fatalField investigationFinal reportCessna 401A · Whick, KYThe non-instrument-rated pilot's continued flight into instrument meteorological conditions, and his subsequent failure to maintain airspeed which resulted in an inadvertent stall. Contributing was the instrument meteorological conditions.NTSB NYC06CA213Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Frederick, MDThe flight instructor's delayed remedial action during a hovering autorotation, which resulted in a hard landing and inadvertent dynamic rollover.NTSB LAX06LA275Accident · 2 fatalLimited investigationFinal reportTerry Tevis RV-6A · Novato, CAThe pilot's failure to maintain terrain clearance while maneuvering. Rising terrain, fog and dark night conditions were factors.NTSB LAX06LA274Accident · Minor injuriesLimited investigationFinal reportNorth American Navion A · El Centro, CAThe partial loss of engine power during takeoff, as a result of air being sucked into the fuel system due to a worn fuel selector valve stem and a bent detent ring.NTSB LAX06FA277Accident · Minor injuriesField investigationFinal reportRaytheon Hawker 800XP · Smith, NVThe failure of the glider pilot to utilize his transponder and the high closure rate of the two aircraft, which limited each pilot's opportunity to see and avoid the other aircraft.NTSB LAX06CA278Accident · No injuriesData collectionFinal reportGlaser Dirks DG 300 · Truckee, CAthe pilot's misjudged landing approach that led to a runway overshoot. A contributing factor was the pilot's hypoxic condition.NTSB DFW06CA204Accident · No injuriesData collectionFinal reportRon Burleigh Air Cam · Post, TXThe pilot's failure to maintain clearance with power lines while making a precautionary landing.NTSB CHI06FA245Accident · 1 fatalField investigationFinal reportCirrus SR22 · Indianapolis, INThe pilot's failure to maintain sufficient airspeed, which resulted in a stall and subsequent spin. Contributing to the accident were the pilot's inadequate preflight planning, the overloaded condition of the airplane, and the CG aft of the CG limit.NTSB SEA06LA169Accident · 1 fatalLimited investigationFinal reportCurtiss-Wright Travel Air C-4000 · Elmira, ORThe pilot's failure to maintain an airspeed above stall speed (Vs) while turning to avoid trees along the side of the runway during the initial climbout after takeoff. Factors include, a variable wind that became a tailwind, and trees growing near the side of…