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 DEN93LA067Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5 · Watkins, COSpatial disorientation which prevented the pilot from maintaining control. A factor was: low ceiling.NTSB CHI93LA211Accident · No injuriesLimited investigationFinal reportMonnett Sonerai IIL · De Kalb, ILThe pilot in command's inability to maintain directional control due to inadequate compensation for wind conditions.NTSB CHI93LA197Accident · No injuriesLimited investigationFinal reportCessna 210L · Indianola, IAA fatigue fracture of the crankshaft.NTSB CHI93LA191Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Kewanee, ILThe pilot's failure to refuel the airplane prior to fuel exhaustion. A factor in the accident is the pilot's inadvertent stall/mush during the forced landing.NTSB ATL93LA105Accident · Serious injuriesLimited investigationFinal reportCessna 172D · Ridgeland, SCThe pilot's improper use of carburetor heat, which resulted in a partial loss of engine power. Factors were the carburetor icing conditions, and the soft terrain at the forced landing site.NTSB ANC93LA082Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Skwentna, AKThe pilot in command not maintaining directional control of the airplane. A factor in the accident was the gusty wind condition.NTSB ANC93LA080Accident · No injuriesLimited investigationFinal reportCessna 180A · Anchorage, AKThe pilot's failure to maintain direction control of the airplane during landing. The tailwind was a factor.NTSB ANC93FA081Accident · Minor injuriesField investigationFinal reportCessna A185E · Anchorage, AKThe pilot in command exceeding the maximum authorized gross takeoff weight of the airplane and his failure to compensate for the wind conditions. A factor in the accident was the gusty wind condition.NTSB NYC93LA107Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Linden, NJThe pilot's misjudgement of speed and distance which resulted in an overrun of the runway. A wet runway is a contributing factor.NTSB MIA93LA138Accident · No injuriesLimited investigationFinal reportCessna 152 · Sarasota, FLPilot in command's failure to ensure the aircraft contained enough fuel to complete the flight resulting in the engine failing due to fuel exhaustion.NTSB LAX93LA243Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Montgomery Pass, NVThe pilot's poor preflight planning/preparation and intentional flight into instrument meteorological conditions. Factors relating to this accident were the downdraft, low ceiling, rain, obscuration, and the mountainous terrainNTSB LAX93FA241Accident · 3 fatalField investigationFinal reportLancair 320 · Chino, CAInadequate visual lookout by the pilot of the Lancair 320, N69WD, that precluded him from recognizing a collision hazard and taking action to avoid a midair collision with the Cessna 152, N80203. In addition, the local controller failed to advise the pilot of…NTSB FTW93LA179Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Kaplan, LAThe pilot's failure to have the airplane properly attended during start when people were available. A factor was the inadequate tie down rope.NTSB FTW93LA178Accident · No injuriesLimited investigationFinal reportBell-Transworld 47G-2 · Wynne, ARPartial power loss due to the failure of one magneto. A factor was the lack of suitable terrain for the forced landing.NTSB FTW93LA177Accident · No injuriesLimited investigationFinal reportWeatherly 620B · Crowley, LASevere propeller and airframe vibration for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB DEN93FA066Accident · Minor injuriesField investigationFinal reportCessna 310J · Broomfield, COFriction of escaping oxygen under high pressure igniting a lubricant in the nosewheel well area, and improper aircraft servicing by maintenance personnel.NTSB CHI93DEE01Accident · No injuriesFinal reportMark Streitz Skybolt · Joliet, ILthe failure of the number two connecting rod bolt.NTSB ATL93LA106Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Centre, ALThe pilot's failure to maintain clearance from trees during agricultural application maneuvering. Factors were the trees in the vicinity of the planned flight path.NTSB ATL93LA104Accident · Minor injuriesLimited investigationFinal reportHatz CB-1 · Stedman, NCThe improper positioning of the main fuel tank drain, which resulted in fuel starvation and engine stoppage. A factor were trees in the forced landing area.NTSB ATL93LA103Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Ravenel, SCThe continuation of the landing attempt into the short sod field without the use of flaps and the use of excessive airspeed by the pilot. Factors in the accident were the failure of the aircraft flaps to extendNTSB ANC93T#A01Accident · No injuriesClass 3Final reportCessna A185F · Gulkana, AKNTSB SEA93LA128Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Havre, MTThe pilot in command misjudged his clearance from a ditch, and his use of improper remedial action.NTSB NYC93LA103Accident · No injuriesLimited investigationFinal reportCessna 152 · West Chester, PAImproper recovery from a bounced landing which resulted in the airplane departing the side of the runway and striking trees.NTSB NYC93LA099Accident · Serious injuriesLimited investigationFinal reportBellanca 17-31 · Leesport, PAThe loss of engine power for undetermined reasons, which resulted in forced landing and collision with trees.NTSB LAX93FA246Accident · 4 fatalField investigationFinal reportBeech S35 · Lovelock, NVThe pilot's continuation of VFR flight into instrument meteorological conditions. Factors which contributed to the accident were: the adverse weather conditions and mountainous terrain.NTSB FTW93LA182Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Ozona, TXThe pilot's failure to correctly compensate for wind conditions. A factor was the unexpected encounter with the crosswind.NTSB FTW93FA176Accident · 1 fatalField investigationFinal reportPiper PA-36-285 · Texhoma, TXThe pilot's flight into known adverse weather conditions. Factors were the weather, the dark night, the airplane's lack of flight and navigational equipment, and the pilot's lack of instrument training and experience.NTSB CHI93LA192Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR-72-212 · Chicago, ILThe pilot in command's improper in-flight planning/decision.NTSB CHI93LA188Accident · No injuriesLimited investigationFinal reportBeech C23 · Kansas City, MOThe pilot-in-command was operating the airplane at an excessive taxi speed, and did not maintain visual separation with the tied down airplane. Factors contributing to the accident were a light rain and fog condition, and a foggy interior window.NTSB ANC93LA078Accident · No injuriesLimited investigationFinal reportCessna 206G · Igiugig, AKThe pilot in command selected unsuitable terrain for landing.NTSB SEA93LA127Accident · No injuriesLimited investigationFinal reportCessna 210L · Lynden, WADirectional control not being maintained. Factors include a high touchdown speed, light rain, and a wet landing surface.NTSB LAX93LA240Accident · No injuriesLimited investigationFinal reportCessna 150D · Biggs, CAThe first pilot's premature lift-off and his failure to maintain directional control.NTSB FTW93WA270Accident · 3 fatalForeign investigationAero Commander 680F · Chihuahua, MexicoNTSB FTW93WA259Accident · 3 fatalForeign investigationCessna 180G · Huazapares, MexicoNTSB DEN93LA065Accident · No injuriesLimited investigationFinal reportCessna 182A · Stratton, COThe selection of unsuitable terrain for a precautionary landing by the pilot in command. A factor was: misjudging the deteriorating weather.NTSB CHI93DEM01Accident · No injuriesFinal reportAmato Corben JR. ACE · Traverse City, MIinadequate lubrication of the tailwheel bearings and inadequate preflight by the pilot/owner which resulted in a seized tailwheel.NTSB ATL93LA102Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Greensboro, NCThe pilot's improper use of carburetor heat during the flight. Factors were the carburetor icing conditions at the time of the accident, and trees at the forced landing siteNTSB LAX93LA237Accident · Minor injuriesLimited investigationFinal reportSchmidt JURCA-MJ55 · Bakersfield, CALoss of engine power for undetermined reasons.NTSB FTW93LA175Accident · No injuriesLimited investigationFinal reportGrumman G-164B · St. Martinville, LAThe pilot's and tractor driver's inadequate visual lookoutNTSB FTW93LA174Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Stuttgart, ARThe pilot's selection of the downwind runway for landing. Factors were the wind conditions and the left brake malfunction for undetermined reasonsNTSB FTW93LA173Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Ganado, TXThe pilot's failure to maintain clearance with the power linesNTSB FTW93LA172Accident · Serious injuriesLimited investigationFinal reportGrumman G-164B · Walnut Ridge, ARThe pilot's failure to maintain adequate clearance.NTSB ATL93LA100Accident · No injuriesLimited investigationFinal reportCessna 172 · Tuskegee, ALThe pilot's failure to establish a final approach course to the runway surface during a night landing. A factor was the inoperative aircraft landing light.NTSB ANC93LA077Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Skagway, AKA total loss of engine power as a result of a fatigue failure of the #2 connecting rod. A factor which contributed to the accident was the lack of suitable terrain for the emergency landing.NTSB NYC93LA098Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Gordonsville, VAWas a power loss due to fuel contamination, after the pilot refueled from cans and did not filter the fuel according to recommendations.NTSB NYC93LA097Accident · 1 fatalLimited investigationFinal reportCessna A188B · Marengo, OHThe pilot's misjudged clearance from obstacles during aerial application, resulting in a collision with trees. A factor in this accident was the pilot's lack of total experience in aerial application flying.NTSB MIA93FA137Accident · 2 fatalField investigationFinal reportCessna 152 · Miami, FLThe pilot-in-command's failure to maintain airspeed while maneuvering at low altitude. A factor which contributed to the accident was the pilot's failure to maintain an adequate altitude from which a recovery would have been possible.NTSB LAX93T#A08Accident · No injuriesFinal reportHughes 369D · La Jolla, CANTSB LAX93LA238Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Pacoima, CAA failure of the pilot to adequately compensate for cross wind conditions and a failure to maintain directional control of the airplane.NTSB ATL93LA099Accident · No injuriesLimited investigationFinal reportRockwell 114 · Woodstock, GAThe pilot's inadequate preflight planning which resulted in his failure to abort the takeoff when sufficient runway was available.