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 LAX94LA381Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Woodland, CAthe failure of the pilot to maintain an adequate airspeed during a short field approach and the inadvertent entry into a stall/mush condition. In addition, the instructor failed to take proper remedial action.NTSB LAX94LA377Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · San Mateo, CAA deteriorated magneto grounding ('P' lead) and failure of maintenance personnel to detect this condition when the engine was reinstalled in the airframe after overhaul. The lack of suitable terrain for the forced landing was a factor.NTSB FTW94LA312Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Galena, AKThe pilot's excessive use of brakes during landing. A factor was the unfavorable winds at the remote landing area.NTSB FTW94LA310Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Nikiski, AKThe pilot's improper descent rate. A factor was the check pilot's inadequate supervision.NTSB FTW94LA309Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Denton, TXThe fuel starvation induced power loss due to the pilot's failure to maintain an adequate amount of fuel. Factors which contributed were: the lack of suitable terrain for the forced landing, and the pilot's evasive maneuver.NTSB CHI94LA347Accident · No injuriesLimited investigationFinal reportMaule MX-7-235 · Washburn, NDthe pilot's failure to maintain sufficient airspeed during the landing flare. Factors associated with the accident were the poorly planned approach and the soft terrain.NTSB CHI94DEV02Accident · Serious injuriesFinal reportThomas E. Georges Z-MAX · Palmyra, ILThe pilots's inadvertently stalled the airplane while maneuvering to land. Factors were the loss of engine power due to carburetor ice, carburetor icing conditions, and the unavailability of carburetor heat.NTSB ATL94LA177Accident · No injuriesLimited investigationFinal reportCessna 172D · Alabaster, ALThe pilot's failure to properly sump the fuel system during the preflight inspection that resulted in loss of power.NTSB LAX94LA387Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Pacific Ocean (Pacific Ocean)failure of the helicopter's main rotor pitch change link (control rod). The helicopter was not recovered and the Safety Board was unable to determine the pitch change link's failure mode.NTSB LAX94LA385Accident · No injuriesLimited investigationFinal reportCessna 152 · Fallbrook, CAThe student pilot's inadequate recovery from a bounced landing.NTSB LAX94LA376Accident · 1 fatalLimited investigationFinal reportCessna 182Q · Las Vegas, NVthe pilot's failure to shut down the engine before deplaning a passenger.NTSB LAX94LA375Accident · 2 fatalLimited investigationFinal reportCorley Lancair · Ramona, CAthe pilot's premature lift-off and failure to obtain the requisite minimum airspeed for flight, failure to maintain control of his airplane, and inadvertent stalling during initial climb. Factors which contributed to the accident related to the pilot's…NTSB FTW94LA313Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Byers, COFailure by the pilot to maintain a proper descent rate during approach to landing. A factor was lack of experience in make, model, and type of aircraft.NTSB CHI94LA349Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Williamsport, INThe continued flight into adverse weather conditions, the student's failure to maintain a proper glideslope and the CFI's delay in initiating remedial action. Factors related to the accident were the lightning and turbulent thunderstorm conditions.NTSB MIA94LA216Accident · No injuriesLimited investigationFinal reportBell 47G-2A · Moore Haven, FLThe pilot-in-command's failure to maintain a visual lookout while maneuvering on a swath run, resulting in an in-flight collision with wires, and subsequent in-flight collision with terrain.NTSB LAX94LA374Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Chico, CAthe student pilot's improper use of the flight controls. The student pilot's lack of experience in the helicopter is a factor in this accident.NTSB FTW94LA308Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Monte Vista, COThe pilot's failure to maintain directional. Factors were the cross wind conditions, and the pilot's poor evaluation of the weather.NTSB DCA94WA077Accident · 2 fatalForeign investigationAero Commander 500S · Westman Isles, IcelandNTSB CHI94LA348Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Dale, INthe pilot's failure to assure an adequate fuel supply for the flight. Factors associated with the accident were poor preflight planning, inattentiveness to the fuel supply during the flight, the ditch, and the utility pole which was contacted during the…NTSB CHI94LA345Accident · No injuriesLimited investigationFinal reportCessna 150G · New Town, NDThe pilot's improper use of wing flaps and premature lift-off. The pilot's poor preflight preparation was a factor.NTSB ATL94LA178Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235B · Kill Devil Hill, NCThe pilot's failure to assure that the passenger did not exit the airplane while the propeller was still turning.NTSB SEA94FA245Accident · 2 fatalField investigationFinal reportCessna A185E · Juneau, AKAttempted VFR flight into IMC. Factors to the accident were: clouds and mountainous terrain.NTSB NYC94LA182Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Buffalo, NYThe pilot's improper recovery from a bounced landing. A factor is the pilot's improper landing flare.NTSB LAX94FA372Accident · Minor injuriesField investigationFinal reportHughes 369D · Genoa, NVThe pilot/operator's operation of the helicopter with a disconnected throttle on the right collective; the FAA inspector's inadequate preflight/pretakeoff checks of the flight control/throttle systems; and the pilot/operator's failure to adequately inform the…NTSB ATL94LA176Accident · No injuriesLimited investigationFinal reportMooney M20J · Chamblee, GAThe pilot's improper flare that resulted a in hard landing, followed by his improper recovery from a bounced landing, and his failure to maintain directional control during the attempted go- around.NTSB LAX94LA384Accident · No injuriesLimited investigationFinal reportCessna 152 · Petaluma, CAthe failure of the pilot to initiate a go-around after failing to obtain the proper airspeed and rate of descent during the approach.NTSB LAX94LA371Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Benson, AZthe pilot's failure to maintain adequate main rotor rpm during a go-around attempt.NTSB LAX94LA370Accident · 1 fatalLimited investigationFinal reportJames B. Edwards Cozy · Skull Valley, AZThe pilot's poorly planned approach by failing to maintain the proper airspeed and alignment. The pilot's total expereince, and lack of experience in the airplane make and model were factors in this accident.NTSB CHI94LA342Accident · No injuriesLimited investigationFinal reportCessna 152 · Plainwell, MIthe pilot's failure to maintain directional control of the airplane during the landing roll. A factor in the accident was the pilot's lack of total experience.NTSB ATL94LA174Accident · No injuriesLimited investigationFinal reportCessna 152 · Linden, TNThe pilot's improper use of the rudder which resulted in a loss of directional control.NTSB NYC94LA181Accident · No injuriesLimited investigationFinal reportCessna 172P · Sterling, MAThe pilot misjudged landing distance, which resulted in an overrun of the runway. A factor is the pilot's failure to do a go-around.NTSB NYC94LA180Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Oakland, MDthe pilot's inadequate preflight planning and preparation in which the pilot attempted a high density altitude takeoff, up-slope, with the airplane over the maximum allowable gross weight, utilizing a rolling takeoff technique with an improper flap setting.…NTSB MIA94WA215Accident · No injuriesForeign investigationPiper PA32R-301T · Long Island, BahamasNTSB FTW94LA306Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Mcgehee, ARThe loss of engine power due to undetermined reasons. A factor was the unsuitable terrain.NTSB CHI94LA350Accident · No injuriesLimited investigationFinal reportUltralight Challenger II · Princeton, ILInadequate directional stability of the aircraft (due to installation of lexan cockpit enclosure doors), which precipitated a loss of directional control.NTSB CHI94LA341Accident · No injuriesLimited investigationFinal reportDooley, James M Velocity · Valparaiso, INthe pilot-in-command's improper use of the elevator trim. A factor was the pilot-in-command's lack of total experience in type of aircraft.NTSB CHI94LA337Accident · 1 fatalLimited investigationFinal reportPiper PA-20 · Greenville, MIIncapacitation of the pilot due to a seizure and/or loss of consciousness. A factor related to the accident was: the pilot's failure to properly report his medical information on his FAA medical application.NTSB CHI94FA340Accident · 1 fatalField investigationFinal reportBeech E95A · Poplar Grove, ILAircraft control not maintained by the pilot when he began his turn from base leg to final approach. Factors associated with this accident were the fatigue failure of a propeller blade, improper maintenance overhaul of the propeller, and a material defect in…NTSB ATL94LA173Accident · No injuriesLimited investigationFinal reportBeech M35 · Winston-Salem, NCThe student pilot's failure to maintain airspeed and a proper glidepath on final approach, resulting in an inadvertent stall and undershoot. Factors were the night lighting conditions, and the flight instructor's inadequate supervision of the student pilot.NTSB MIA94LA214Accident · Serious injuriesLimited investigationFinal reportBoeing 737-400 · Atlantic Ocean (Atlantic Ocean)The inflight encounter with turbulence in clouds.NTSB MIA94FAMS2Accident · 5 fatalMissing aircraftFinal reportPiper PA-23-250 · MissingUndetermined.NTSB FTW94LA305Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Nacogdoches, TXThe pilot's inadequate compensation for crosswind during landing rollout. A factor was the variable crosswind.NTSB FTW94LA302Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Houston, TXThe pilot's loss of directional control during the go around.NTSB CHI94LA343Accident · No injuriesLimited investigationFinal reportCessna 150 · North Hedrick, IAInadequate preflight planning and the selection of unsuitable terrain on which to initiate a takeoff. A factor in this accident was the pilot's lack of overall experience.NTSB CHI94LA339Accident · No injuriesLimited investigationFinal reportCessna 150 · Lansing, KSthe pilot's failure to maintain directional control during an aborted takeoff. A factor related to the accident was the delay in aborting the takeoffNTSB SEA94LA243Accident · No injuriesLimited investigationFinal reportCessna 172N · Orcas, WAThe pilot's improper landing flare.NTSB SEA94LA242Accident · Minor injuriesLimited investigationFinal reportCessna P206D · Lopez, WAA worn throttle control lever.NTSB SEA94LA241Accident · No injuriesLimited investigationFinal reportOestreich Avid Flyer MK IV · Moses Lake, WAProper descent rate was exceeded. Lack of total experience in type operation was a factor.NTSB NYC94LA179Accident · Minor injuriesLimited investigationFinal reportCessna 172M · New London, PAThe pilot failed to maintain adequate airpseed which resulted in an inadvertent stall and inflight collision with terrain.NTSB MIA94LA213Accident · 1 fatalLimited investigationFinal reportRans S-12 Airaile · Clearwater, FLThe loss of engine power for undetermined reasons.