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 LAX96LA099Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Oroville, CAthe failure of the pilot to use carburetor heat, which resulted in loss of engine power due to carburetor ice. The carburetor icing (weather) condition was a related factor.NTSB FTW96LA109Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Grand Prairie, TXa loss of power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW96LA107Accident · Minor injuriesLimited investigationFinal reportBoeing B75N1 · Bernal, NMthe pilot's improper planning/decision, including his failure to maintain sufficient altitude/clearance from mountainous terrain to compensate for altitude deviations that resulted from mountain wave/wind conditions. Factors relating to the accident were: the…NTSB FTW96FA108Accident · Serious injuriesField investigationFinal reportCessna 152 · Conway, ARloss of engine power for undetermined reason(s), and failure of the pilot to maintain adequate airspeed, while maneuvering for a forced landing, which resulted in an inadvertent stall at low altitude. The gusty wind condition was a related factor.NTSB BFO96LA041Accident · No injuriesLimited investigationFinal reportCessna 172D · Rineyville, KYthe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB ATL96LA041Accident · No injuriesLimited investigationFinal reportBeech 23 · Mc Coll, SCthe pilot's failure to maintain aircraft control.NTSB ATL96LA040Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Knoxville, TNFailure of the pilot to maintain sufficient airspeed during a go-around, which resulted in a stall.NTSB MIA96WA069Accident · No injuriesForeign investigationPiper PA-23-250 · North Caicos, Turks & Caicos IslandsNTSB MIA96LA073Accident · Minor injuriesLimited investigationFinal reportGilpatrick Baby Lakes · Deland, FLThe pilot's misjudgment of distance and altitude, while on final approach to land, and his failure to attain the proper touchdown point for landing. The unfavorable wind condition (crosswind) was a related factor.NTSB LAX96LA101Accident · No injuriesLimited investigationFinal reportBoeing A75 · Barstow, CAa loss of engine power for an undetermined reason(s).NTSB CHI96LA084Accident · No injuriesLimited investigationFinal reportConnell Kitfox · Omaha, NEthe pilot's inadequate preflight of the aircraft and the frozen left landing gear wheel.NTSB BFO96LA040Accident · Serious injuriesLimited investigationFinal reportAerostar 601 · Mount Storm, WVloss of power in the right engine for undetermined reason(s), and the accumulation of structural ice on the airplane, which resulted in an increased rate of descent and a subsequent forced landing before the pilot could reach an alternate airport. Factors…NTSB ANC96LA025Accident · No injuriesLimited investigationFinal reportCessna 206 · Kotzebue, AKThe pilot's poor judgment in conducting the flight in the existing high gusting wind conditions. A factor associated with the accident was the operator allowing/dispatching the accident flight in the prevailing weather conditions, and the icy ramp/taxi area.NTSB CHI96LA085Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Sandstone, MNthe pilot's selection of an ice-covered runway for takeoff. A factor was the icy runway.NTSB NYC96LA055Accident · No injuriesLimited investigationFinal reportCessna 150M · Readington, NJThe student pilot's unapproved landing at a second destination during his first solo cross-country, and his inadequate compensation for a cross wind, which resulted in the airplane veering off of the runway and the subsequent nose over.NTSB MIA96LA072Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Quincy, FLThe pilot's inadequate compensation for wind conditions, while beginning a flare to land, which resulted in a loss of aircraft control and collision with the ground.NTSB CHI96LA081Accident · No injuriesLimited investigationFinal reportBeech 58 · Yipsilanti, MIwas the pilot not maintaining visual separation with the parked airplanes. A factor in this accident was the pilot's over- confidence in his personal ability to taxi onto the parking ramp with the snowfall he was encountering.NTSB MIA96LA071Accident · Serious injuriesLimited investigationFinal reportCessna 310R · Fort Pierce, FLfailure of the pilot to follow emergency procedure(s) and/or feather the respective propeller after loss of power in the left engine for an undetermined reason. The undetermined loss of power (left engine) was a related factor.NTSB CHI96LA082Accident · No injuriesLimited investigationFinal reportDassault DA-10 · Romulus, MIfailure of the right landing gear locking mechanism.NTSB MIA96FA068Accident · No injuriesField investigationFinal reportMcDonnell Douglas MD-11 · Miami, FLThe local and ground controllers' failure to adequately coordinate the movement of the two airplanes, the tower cab supervisor's failure to provide adequate supervision to the controllers, the MD-11 flightcrew's misinterpretation of the local controller's…NTSB BFO96FA039Accident · 2 fatalField investigationFinal reportCessna R172K · Highland Hills, OHthe pilot's continued VFR flight into instrument meteorological conditions at a low altitude with known obstacles in the area.NTSB ATL96LA039Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Greenville, SCthe failure of the student pilot to maintain airspeed while raising the flaps during the go-around.NTSB ATL96LA038Accident · No injuriesLimited investigationFinal reportCessna 172 · Sanford, FLthe pilot-in-command's excessive taxi speed and his failure to maintain adequate clearance from obstacles.NTSB NYC96LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Norwood, MAFailure of the student pilot to maintain directional control of the airplane after touchdown, which resulted in an inadvertent ground swerve and collision with a snowbank.NTSB LAX96FA098Accident · 2 fatalField investigationFinal reportCessna T-210N · Gorman, CAThe loss of control of the aircraft in cruise flight for undetermined reasons and subsequent in-flight structural failure of the aircraft.NTSB FTW96LA103Accident · No injuriesLimited investigationFinal reportCessna A185F · Belle Chase, LAThe pilot's inadequate compensation for the wind conditions, which resulted in a loss of directional control and subsequent encounter with a ditch. The crosswind was a related factor.NTSB CHI96FA083Accident · 1 fatalField investigationFinal reportPiper PA-46-350P · Carlyle, ILspatial disorientation of the pilot, and his failure to maintain control of the airplane, which resulted in his exceeding the design stress limits of the airframe. A factor relating to the accident was: turbulence in clouds.NTSB ANC96LA170Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Skwentna, AKThe pilot's selection of an unsuitable site for landing. A factor associated with the accident is the snow-covered terrain.NTSB FTW96LA104Accident · No injuriesLimited investigationFinal reportCessna 172N · Norman, OKthe student pilot's improper level-off during landing.NTSB FTW96LA102Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Spicewood, TXthe pilot's intentional evasive maneuver to avoid colliding with a deer on the runway during landing. A factor was the bush that the airplane collided with during the aborted landing.NTSB FTW96FA100Accident · 4 fatalField investigationFinal reportBeech 58 · Atkins, ARContinued flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude above mountainous/hilly terrain. Factors relating to the accident were: low ceiling, fog, and high terrain in the area of the…NTSB MIA96WA070Accident · Minor injuriesForeign investigationBell 206 · Exuma, BahamasNTSB LAX96FA097Accident · Minor injuriesField investigationFinal reportPiper PA-28-236 · Seal Beach, CAa total loss of engine power from an improperly installed magneto that separated from the engine housing due to fatigue from vibration.NTSB LAX96FA096Accident · 2 fatalField investigationFinal reportBeech 55 · Cedarville, CAthe pilot's poor preflight planning by not obtaining a weather briefing and his inadvertent encounter with a mountain wave condition. The moonless dark night was a factor in this accident.NTSB FTW96LA101Accident · No injuriesLimited investigationFinal reportCessna 180 · Buena Vista, COThe pilot's inadequate compensation for the wind conditions, and his failure to maintain directional control. A factor relating to the accident was: the crosswind.NTSB NYC96LA053Accident · Minor injuriesLimited investigationFinal reportMitsubishi MU-2B-6 · Allentown, PAthe pilot's failure to comply with IFR procedures in that he attempted an instrument approach with visibility below the required minimums, and his delayed execution of a missed approach. A factor was the reduced visibility due to clouds.NTSB MIA96LA066Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Smithville, TNThe pilot's improper in-flight planning/decision, which resulted in a heavy load of airframe ice, an inability to maintain altitude, and a subsequent emergency landing. Factors relating to the accident were: the adverse weather (icing) condition, which was…NTSB MIA96FA067Accident · Serious injuriesField investigationFinal reportMitsubishi MU-2B-60 · West Columbia, SCa total loss of power on one engine for undetermined reasons, and the pilot-in-command's failure to maintain airspeed (VMC) resulting in an in-flight loss of control. Contributing to the accident was the wind gusts encountered while on final approach to land.NTSB FTW96LA105Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Falfurrias, TXfuel starvation due to the pilot's improper positioning of the fuel selector. A factor was the lack of suitable terrain for the forced landing.NTSB ATL96FA037Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Fort Pierce, FLimproper re-assembly of the engine induction air filter by maintenance personnel, during an annual inspection, which resulted in a loss of engine power during takeoff; failure of the pilot to abort the takeoff before lift-off; and failure of the pilot to…NTSB NYC96FA052Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Harwich, MAthe pilot's improper in-flight decision to continue flight under visual flight rules, while flying into instrument meteorological conditions. Also causal was the pilot's failure to maintain control of the airplane after entering IMC, which resulted in the…NTSB MIA96LA095Accident · No injuriesLimited investigationFinal reportRotor Flight Dynamics Dominator · Quincy, FLa partial loss of engine power due to fuel contamination, and the pilot-in-command's improper decision to land with a tailwind.NTSB FTW96LA098Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Las Vegas, NMfailure of the throttle cable. A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB FTW96FA091Accident · 1 fatalField investigationFinal reportMooney M20K · Laredo, TXThe pilot's loss of aircraft control. A factor was the dark night conditions.NTSB MIA96FA064Accident · Serious injuriesField investigationFinal reportAirbus Industrie A-300B4-605R · Atlantic Ocean (Atlantic Ocean)the turbulence and failure of the passengers to have their seat belts fastened. A factor relating to this accident was: the failure of the aircraft operator to advise the flight crew of forecast active intensifying thunderstorm conditions in the area of the…NTSB CHI96FA113Accident · 1 fatalField investigationFinal reportPiper PA-32 · Milwaukee, WIInadequate maintenance and inspection in that the Airworthiness Directive which applied to the fuel pump had not been complied with. A factor was the pilot was unable to reach land.NTSB SEA96LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · Ogden, UTThe pilot's improper flare and inadequate recovery from a bounced landing. His improper approach was a related factor.NTSB NYC96LA051Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Auburn, METhe pilot's improper planning/decision and failure to attain proper alignment with the landing area. Factors relating to the accident were: darkness, and the inoperative radio transmitter, which precluded the pilot from activating the runway lights.NTSB FTW96LA099Accident · No injuriesLimited investigationFinal reportCessna 182K · Covington, LAthe pilot's delayed touchdown which resulted in a landing with inadequate runway remaining under the wet runway condition. A factor was the wet grass runway.NTSB ATL96FA036Accident · 2 fatalField investigationFinal reportPiper PA-46-350P · Peachtree City, GAThe pilot's failure to follow the published instrument approach procedure. The fog was a factor.