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 MIA92LA159Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Toney, ALThe left main landing gear attachment bolt failed for undetermined reasons resulting in the collapse of both main landing gear during the take off roll.NTSB LAX92LA334Accident · No injuriesLimited investigationFinal reportMooney M20-M · Sedona, AZThe pilot's improper recovery from a bounced landing and delayed go-around decision. Contributing to the accident was a failure of the pilot to attain the touch-down during a down wind landing.NTSB FTW92FA201Accident · 1 fatalField investigationFinal reportCessna 172P · Breckenridge, TXAn inadvertent stall.NTSB FTW92DPG11Accident · No injuriesFinal reportGrumman G-164B · Fouke, ARThe pilot's selection of unsuitable terrain for takeoff. Factors were the trees and the soft field.NTSB ANC92LA118Accident · No injuriesLimited investigationFinal reportCessna 207A · Pilot Station, AKThe total loss of engine power for undetermined causes, and the unsuitable terrain.NTSB SEA92T#A04Accident · No injuriesClass 3Final reportBell 205A-1 · Arco, IDNTSB NYC92WA141Accident · 1 fatalForeign investigationCessna Reems F172 · Munich, GermanyNTSB LAX92LA328Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Burbank, CAThe binding and over temperature of an exhaust valve due to the lack of compliance with factory service instructions and bulletins regarding valve sticking by other maintenance personnel.NTSB LAX92FA331Accident · 1 fatalField investigationFinal reportCessna 152 · Maricopa, AZThe pilot exceeded the design stress limits of the airplane structure by attempting an abrupt maneuver at a speed in excess of the maneuvering speed.NTSB LAX92FA330Accident · 2 fatalField investigationFinal reportMercury 1 · Pacifica, CAThe pilot's decision to attempt visual flight in instrument meteorological conditions.NTSB FTW92LA200Accident · Serious injuriesLimited investigationFinal reportBoeing 737-300 · Springfield, MOThe encounter with severe turbulence while deviating around convective activity.NTSB FTW92LA199Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Monroe, LAThe pilot's failure to maintain adequate rotor RPM during autorotation. Factors were the tailwind and the power loss for undetermined reasons.NTSB DEN92LA080Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Karval, COAn engine failure due to improper maintenance installation. A factor was: lack of suitable terrain for the forced landing.NTSB CHI92FA223Accident · 2 fatalField investigationFinal reportEdra/Mcdermitt Seabird/Petrel · Oshkosh, WIInadequate quality control during the manufacturing process resulting in the in-flight structural failure of the tailboom.NTSB ATL92FA152Accident · 1 fatalField investigationFinal reportPiper PA-24-400 · Dovesville, SCThe loss of engine power which resulted from an undetermined malfunction of the ignition system. A factor was fog.NTSB MIA92FA158Accident · 4 fatalField investigationFinal reportCessna 172K · Rockledge, FLFailure of the pilot to maintain adequate airspeed during the final approach resulting in an inadvertent stall. Contributing to the accident was the pilot's lack of recent experience in the type operation, lack of experience at the airport in the type…NTSB CHI92LA225Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Whitman, NEWater contamination in the fuel and low magneto output.NTSB CHI92LA221Accident · Minor injuriesLimited investigationFinal reportStitts SA-11A · Oshkosh, WIThe pilot's failure to maintain control of the homebuilt airplane during the landing. A related factor was the pilot's improper planned approach.NTSB CHI92FA228Accident · 3 fatalField investigationFinal reportCessna 172H · Grayling, MIThe pilot's failure to maintain aircraft control.NTSB CHI92FA218Accident · 1 fatalField investigationFinal reportBull KR-2 · Oshkosh, WIA loss of control in flight due to pilot incapacitation as a result of a heart attack.NTSB ATL92LA150Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Ocracoke, NCThe student pilot's failure to maintain directional control during the landing roll. Factors were the pilot's lack of recent total experience, and the crosswind conditions, and the dirt bank adjacent to the runway.NTSB ATL92IA151Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-11 · Los Angeles, CAThe pilot in command's improper use of the aircraft flight controls (elevator) during the landing, which resulted in the aircraft tail contacting the runway surface.NTSB SEA92LA171Accident · No injuriesLimited investigationFinal reportBoeing B-75 · Three Forks, MTThe pilot's failure to maintain directional control. Factors include a crosswind gust.NTSB NYC92LA140Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · East Liverpool, OHA collision with trees after the pilot failed to maintain directional control during an aborted landing.NTSB NYC92LA138Accident · No injuriesLimited investigationFinal reportBeech 58 · West Chester, PAAn encounter with windshear which resulted in the airplane landing hard and short of the runway. A factor related to the accident was the gusty wind conditions.NTSB NYC92LA137Accident · Minor injuriesLimited investigationFinal reportDonald L. Betchan KR-II · Louisville, KYImproper use of the flight controls by the prospective buyer, and the failure of the owner/operator to adequately supervise the prospective buyer. Factors related to the accident were the lack of experience in type of airplane for the prospective buyer, and…NTSB NYC92FA139Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · Honesdale, PAA loss of control in flight due to pilot incapacitation as a result of a heart attack.NTSB LAX92T#A18Accident · Minor injuriesClass 3Final reportBell 206L-1 · Jenner, CANTSB LAX92LA329Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Gila Bend, AZFuel exhaustion due to the pilots inadequate preflight and inflight planning, and, his failure to refuel the aircraft.NTSB FTW92LA198Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Hot Springs, ARThe partial loss of engine power due to undetermined reasons. A factor was the unsuitable terrain.NTSB DEN92LA079Accident · No injuriesLimited investigationFinal reportRobert D. Waldron Kitfox III · Fort Collins, COLoss of control which resulted in dragging a wing tip during flare for landing which ended with a ground loop. A factor was: a tail wind.NTSB DEN92FA078Accident · 2 fatalField investigationFinal reportCessna 337A · Ruidoso, NMThe pilot experiencing spatial disorientation and the resultant excessive descent rate. Factors were: the dark night conditions.NTSB CHI92LA222Accident · No injuriesLimited investigationFinal reportHughes 269C · Aurora, ILFatigue fracture of the engine crankshaft resulting in loss of power. Factors were the pilot's excessive descent and his lack of total experience.NTSB CHI92DEC02Accident · 1 fatalFinal reportRans S-9 · Mason, MIThe pilot's over-confidence in his personal ability, his lack of experience in the type airplane he was flying, and the fact the pilot did not maintain a proper airspeed.NTSB ATL92LA149Accident · No injuriesLimited investigationFinal reportCessna 182A · Aiken, SCThe pilot's diverted attention which resulted in the improper use of the elevator and inadvertent porpoise.NTSB ANC92T#A07Accident · No injuriesClass 3Final reportPiper PA-18 · Shishmaref, AKNTSB SEA92LA172Accident · Minor injuriesLimited investigationFinal reportSchweizer SGU 2-22CK · Ephrata, WAThe pilot misjudged the landing flare. Factors include a lack of total pilot expereince.NTSB LAX92LA327Accident · No injuriesLimited investigationFinal reportRockwell 112TC · Glendale, AZA loss of engine power due to excessive carbon deposits on the number one cylinder exhaust valve, and, the pilots attempted operation of the aircraft with known mechanical deficiencies.NTSB LAX92LA326Accident · No injuriesLimited investigationFinal reportHughes 369D · Honolulu, HIThe student's improper use of the flight controls during an attempted recovery from an over rotation during the flare, and, the flight instructor's inadequate supervision of the flight.NTSB LAX92LA324Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Porterville, CAFuel exhaustion due to the student pilot's inadequate preflight and inflight planning, and the failure to refuel the aircraft.NTSB FTW92LA196Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Granbury, TXThe pilot's inadvertent use of carburetor heat during takeoff. The lack of suitable terrain for a forced landing was a factor.NTSB FTW92FA197Accident · 1 fatalField investigationFinal reportBoeing A75 · Cibolo, TXFailure of the engine crankshaft due fatigue and the resultant collapsing of the left wing.NTSB CHI92FA220Accident · 3 fatalField investigationFinal reportBeech V35B · Northwood, NDSpatial disorientation of the pilot in command during initial climb.NTSB CHI92DEX04Accident · Minor injuriesFinal reportAlkire Pietenpol · Delphi, INSeparation of the propeller while in flight, and unsuitable terrain to effect a forced landing.NTSB ANC92LA117Accident · No injuriesLimited investigationFinal reportCessna A-185-F · Anaktuvuk Pass, AKThe pilot in commands improper planning and decision to commence a takeoff in unfavorable wind conditions. Contributing factors to the accident were the impossibility of the pilot to maintain the proper climb rate, the unfavorable wind conditions, and the…NTSB SEA92T#A05Accident · No injuriesClass 3Final reportBell 206L · Enterprise, ORNTSB SEA92LA170Accident · No injuriesLimited investigationFinal reportCessna 411 · Lehi, UTThe failure by the pilot to maintain airspeed above VMC, resulting in loss of control in flight, and his failure to lower the flaps and landing gear for the forced landing. A factor relating to the accident was the pilot's decision to perform fuel system…NTSB LAX92LA325Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Visalia, CAThe pilot's improper stowage of an aerosol spray can in the cockpit which caused an electrical short and an ensuing fire, and his failure to maintain directional control of the aircraft during the subsequent aborted takeoff.NTSB LAX92LA323Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Ravendale, CAThe loss of engine power for undetermined reasons. The short length of the runway was a factor in the accident.NTSB LAX92LA321Accident · No injuriesLimited investigationFinal reportCessna R182 · Redding, CAThe pilots selection of the wrong runway for takeoff under the existing wind conditions.