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 MIA89LA242Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Perry, FLFuel starvation due to wear and restricted movement of the carburetor float, which resulted in loss of engine power. Soft terrain in the emergency landing area contributed to overload failure of the nose gear.NTSB MIA89LA241Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Booneville, MSLoss of engine power for an unknown reason. Trees in the emergency landing area were a factor.NTSB MIA89LA240Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Cayey, PRLoss of engine power for an unknown reason. A factor related to the accident was: the presence of trees in the emergency landing area.NTSB MIA89LA239Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Orlando, FLRetraction of the right main landing gear for an unknown reason.NTSB LAX89FA295Accident · Serious injuriesField investigationFinal reportNorth American P51D · Mar Vista, CAThe pilot's poor in-flight planning in attempting to immediately return to the airport and not following established procedures after the loss of power after takeoff. The failure of an intake valve was a factor in the accident.NTSB FTW89LA157Accident · No injuriesLimited investigationFinal reportCessna 150J · Dallas, TXPilot's failure to accurately calculate the necesary fuel for the flight and assure that the aircraft had been refueled to provide that quantity.NTSB FTW89FA159Accident · 3 fatalField investigationFinal reportCessna 152 · Houma, LAThe failure of both pilots to see-and-avoid each other's aircraft (inadequate visual lookout). A probable factor was: failure of either pilot to issue a traffic advisory.NTSB SEA89LA163Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Paradise Valley, NVThe pilot's inadequate preflight planning/preparation, and his failure to abort the takeoff. The high density altitude, soft runway, and fence were related factors.NTSB SEA89FA156Accident · 1 fatalField investigationFinal reportCessna TU206C · Skykomish, WAThe pilot's decision to continue the flight into IMC. The pilot did not adequately plan and prepare for the flight and was unable to maintain a proper altitude above the terrain for VMC. Fog was a related factor.NTSB NYC89LA211Accident · No injuriesLimited investigationFinal reportCessna 150M · Colts Neck, NJFailure of the pilot to maintain directional control during a rough field takeoff. Contributing factor(s) was: the crosswind and he sunglare in the pilot's eyes.NTSB NYC89LA207Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Sanbornton, NHVFR flight into instrument meteorological conditions (IMC) by the pilot, and his inadequate remedial action to correct the situation. The adverse weather conditions and darkness were related factors.NTSB NYC89FA206Accident · 4 fatalField investigationFinal reportCessna 172P · Northfield, NHThe pilot initiated flight into known adverse weather which resulted in a loss of control. Contributing factor(s) was: the pilot's overconfidence and the existing weather conditions.NTSB MKC89LA195Accident · No injuriesLimited investigationFinal reportBell 47G · Ozark, MOThe failure of the dual student to properly flare during an autorotative landing resulting in a hard landing and partial failure of the right skid. The CFI also failed to properly monitor the student's actions on the flight controls.NTSB MKC89FA194Accident · Serious injuriesField investigationFinal reportCessna 206A · Lees Summit, MOEngine partial power loss due to water in the aircraft fuel system, and an inadequate preflight.NTSB MIA89LA238Accident · No injuriesLimited investigationFinal reportCessna 177 · Woodville, MSImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. Factors related to the accident were: darkness and the ditch.NTSB LAX89LA300Accident · No injuriesLimited investigationFinal reportBeech C23 · Selma, CAThe pilot's failure to maintain proper clearance from the power line, while maneuvering at low altitude. The power line was a related factor.NTSB LAX89LA299Accident · No injuriesLimited investigationFinal reportCessna 150M · Riverside, CAThe student pilot's failure to maintain directional control, which resulted in an inadvertent ground swerve. Factors related to the accident were: the student's lack of recent experience and improper training by her flight instructor.NTSB LAX89DUQ05Accident · 2 fatalFinal reportRuppercht Varieze · California City, CAThe wing failed due to the pilot/owners overtorquing the wing bolts and the improper installation of the wing attach plates/cones.NTSB FTW89LA158Accident · No injuriesLimited investigationFinal reportCessna 172M · Bellville, TXImproper flare by the pilot and his improper recovery from a bounced landing, which resulted in an inadvertent porpoise and subsequent nose gear failure.NTSB DEN89LA215Accident · No injuriesLimited investigationFinal reportCessna 180K · Englewood, COFailure of the pilot to maintain directional control, which resulted in a ground swerve. The crosswind was a related factor.NTSB DEN89LA205Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Philip, SDLoss of engine power for an undetermined reason. Factors related to the accident were: the power line & pole.NTSB BFO89DID02Accident · Serious injuriesFinal reportRotorway Exec · Palmyra, VAInadequate preflight by the pilot, and fuel exhaustion due to an inadequate supply of fuel.NTSB ATL89LA210Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260 · Hanceville, ALImproper flare by the pilot/owner and his failure to obtain/maintain proper airspeed for the go-around; and inadequate supervision and remedial action by the instructor pilot (other crew member). The uneven surface of the private strip was a contributing…NTSB ATL89LA208Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Spruce Pine, NCA loss of power for undetermined reasons. The power loss may have been due to a sticking valve(s).NTSB ATL89LA206Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Hickory, NCPilot's failure to adequately monitor the engine fuel consumption in flight.NTSB ANC89LA156Accident · No injuriesLimited investigationFinal reportde Havilland DHC-3 · Sheenjek River, AKFailure of the pilot to go around when he was unable to attain the proper touchdown point and his excessive application of brakes during the landing. Contributing factors were: the downdraft, excessive remedial action, and soft terrain.NTSB ANC89FA155Accident · Minor injuriesField investigationFinal reportCessna 180 · Anchorage, AKOil leak in the oil cooler. Contributing factors were: oil film on the windshield, which obscured the pilot's vision (visual perception) and hampered his ability to attain proper runway alignment, an object (rock), and high vegetation beside the airstrip.NTSB SEA89LA187Accident · 1 fatalClass 3 · LimitedFinal reportEvans Wittman Tailwind W10 · McCall, IDA collision with terrain for undetermined reasons.NTSB NYC89LA215Accident · No injuriesLimited investigationFinal reportBeech 1900C · Boston, MAThe failure of the ground personnel to safely guide the aircraft so that it would have cleared the jetway.NTSB NYC89LA209Accident · Serious injuriesLimited investigationFinal reportCessna 210 · No. Windham, VTThe pilot's failure to assure an adequate supply of fuel was available.NTSB LAX89LA298Accident · No injuriesLimited investigationFinal reportStinson 108 · Cool, CAFailure of the #2 piston. Failure of the mechanic to properly overhaul the engine was a related factor.NTSB DEN89LA211Accident · No injuriesLimited investigationFinal reportCessna 182L · Moab, UTInadequate compensation for the wind conditions by the pilot, and his failure to attain a flare. The unfavorable (variable & gusty) wind condition was a related factor.NTSB DEN89LA204Accident · No injuriesLimited investigationFinal reportCessna 150M · Delta, UTFailure of the pilot to maintain directional control which resulted in a ground swerve. Soft terrain beside the runway was a related factor.NTSB ATL89FA207Accident · 2 fatalField investigationFinal reportCessna 152 · Tiptonville, TNThe pilot's failure to maintain a proper climb rate after takeoff. Factors related to the accident were: darkness, the pilot's lack of visual cues, his habit of making shallow climbs after takeoff, his lack of recent night flying experience, and the trees.NTSB ANC89LA159Accident · No injuriesLimited investigationFinal reportCessna 172H · Sparrevohn, AKThe bucket which was blown into the flight path by a crosswind.NTSB ANC89LA158Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Trading Bay, AKSelection of unsuitable terrain (landing area) by the pilot. Contributing factors were: improper information provided by other personnel and a hidden obstruction (log) in tall vegetation (grass).NTSB ANC89LA154Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Iliamna, AKThe pilot's selection of unsuitable terrain for an off-airport operation. Factors related to the accident were: the adverse terrain conditions.NTSB SEA89LA165Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Burns Junction, ORThe pilot did not maintain proper airspeed during takeoff.NTSB SEA89FA155Accident · No injuriesField investigationFinal reportCessna 402B · Seattle, WAThe landing gear down lock mechanism failure.NTSB NYC89LA212Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly · Hatboro, PAImproper in-flight planning/decision by the pilot which resulted in his failure to maintain clearance obstructions. A related factor was: the low level of propane (fuel), which resulted in low burner pressure.NTSB NYC89LA208Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300T · Wolfeboro, NHInadequate compensation for wind conditions by the owner/pilot-in-command (PIC), his failue to maintain proper altitude on the approach, and failure of the other pilot (owner's instructor pilot) to take remedial action. Factors related to the accident were:…NTSB NYC89LA205Accident · No injuriesLimited investigationFinal reportCessna 210N · Westerly, RIThe pilot-in-command's failure to properly ensure a sufficient quantity of fuel for the intended flight.NTSB LAX89LA292Accident · No injuriesLimited investigationFinal reportCessna 172 · Bullhead City, AZFailure of the pilot to adequately perform inflight fuel consumption calculations to ensure the adequacy of the fuel supply for the flight's completion. Contributing to the accident was the failure of the pilot to consider the impact of the stronger than…NTSB LAX89FA294Accident · 1 fatalField investigationFinal reportBeech V35TC · Fort Jones, CAThe failure of the pilot to maintain sufficient altitude.NTSB CHI89LA178Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Brooklyn, MIFailure of the pilot to see-and-avoid power lines in his flight path during a go-around. The power lines and his lack of familiarity with the airport were contributing factors.NTSB CHI89IA180Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-80 · Chicago, ILThe failure of the controller to clarify the confusing communications, to correct the pilot's misinterpretation of the instructions being given, and the failure of the supervisor to properly monitor the situation. Factors related to the incident were the…NTSB BFO89LA078Accident · Serious injuriesLimited investigationFinal reportHughes 269C · Parkersburg, WVThe pilot's inadvertent use (movement) of the collective control during engine operation before shutdown, and a subsequent lift-off, loss of control, roll over, and collision with the ground.NTSB ATL89LA205Accident · No injuriesLimited investigationFinal reportBeech A23-19 · Hertford, NCPilot's failure to properly flare the airplane during landing. Factors contributing to the accident were the high obstructions at both ends of the runway.NTSB ANC89LA153Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Gulkana, AKThe pilots improper use of brakes during the landing roll.NTSB ANC89LA152Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Talkeetna, AKImproper planning/decision by the plt. Contributing factors were rough terrain, rain, high density altitude, tailwind, gusts, and the pilot's improper use of brakes.