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 CHI95LA254Accident · Minor injuriesLimited investigationFinal reportBeech 55 · Delavan, WIThe pilot misjudged the flare and improper recovery from a bounced landing. Lack of experience in the make and model aircraft was a factor.NTSB CHI95LA233Accident · No injuriesLimited investigationFinal reportCessna 172 · Motley, MNthe pilot's failure to maintain control of the airplane during a soft field takeoff.NTSB CHI95LA228Accident · Serious injuriesLimited investigationFinal reportReed RS15 · Ames, IAThe glider pilot's inadequate preflight of the glider by failing to properly secure a push-pull tube to the glider's right ruddervator; and failure of both the glider pilot and the tow pilot to release the tow rope, which led to a stall of the tow airplane.NTSB ATL95LA147Accident · 1 fatalLimited investigationFinal reportQuadcity Challenger I · Anniston, ALThe pilot's failure to maintain airspeed, following an undetermined engine malfunction.NTSB ATL95LA138Accident · 1 fatalLimited investigationFinal reportCessna 188B · Allendale, SCThe pilot's failure to maintain clearance from the guy wire.NTSB ANC95LA107Accident · No injuriesLimited investigationFinal reportHughes 500D · Paxson, AKFuel starvation due to acrylamide contamination in the fuel control inlet filter. The lack of suitable terrain for a forced landing was a related factor.NTSB SEA95LA154Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Roberts, IDA loss of engine power due to the separation of the number 3 cylinder exhaust valve rocker arm shaft from the cylinder head, which disabled movement of the exhaust valve. A factor was the lack of suitable terrain for the forced landing.NTSB SEA95LA150Accident · No injuriesLimited investigationFinal reportCessna 170B · Afton, WYDirectional control was not maintained. Factors to the accident were: inadequate remedial action and a stall not identified.NTSB MIA95WA186Accident · No injuriesForeign investigationCessna A188B · Couva, Trinidad & TobagoNTSB MIA95LA185Accident · No injuriesLimited investigationFinal reportCessna A188B · Aberdeen, MSThe operator's and pilot's procedure of leaving the aircraft unattended with the engine running while loading agricultural chemicals into the aircraft. This resulted in the aircraft moving unattended and colliding with a ditch. Contributing to the accident…NTSB FTW95LA303Accident · No injuriesLimited investigationFinal reportBell 206B · West CameronThe disconnect of the tail rotor drive system for undetermined reasons. Factors were the pilot's inability to maintain directional control, and the lack of suitable terrain for the forced landing.NTSB ANC95LA109Accident · No injuriesLimited investigationFinal reportCessna 150 · Nenana, AKThe pilot's delay in aborting the takeoff. The tailwind was a related factor.NTSB ANC95LA106Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKFailure of the pilot to maintain directional control, which resulted in an inadvertent ground loop/swerve.NTSB NYC95LA159Accident · Serious injuriesLimited investigationFinal reportBeech E35 · Pottsville, PAimproper installation of a fuel line fitting by the pilot/owner which resulted in fuel blockage and subsequent loss of engine power due to fuel starvation.NTSB FTW95LA302Accident · No injuriesLimited investigationFinal reportCessna 182L · Oklahoma City, OKFuel exhaustion due to the pilot's failure to refuel. A factor was the lack of suitable terrain for a forced landing.NTSB CHI95LA225Accident · No injuriesLimited investigationFinal reportCessna 206 · Williston, NDengine failure due to low fuel pressure at high power settings and subsequent detonation. A factor was an evasive maneuver to avoid obstacles which precipitated a stall. Additional factors include the hay bales, farm equipment, and the runway berm.NTSB CHI95DEX01Accident · Minor injuriesFinal reportCraig Long E-Z · Shelbyville, INthe pilot's improper recovery from a bounced landing which resulted in the nose wheel striking the runway first. A factor associated with the accident was excessive airspeed during the landing.NTSB ANC95LA105Accident · No injuriesLimited investigationFinal reportCessna 150 · Kalskag, AKThe loss of engine power for an undetermined reason.NTSB SEA95LA151Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Kent, WAThe pilot's failure to maintain clear of the trees. The dark night light condition was a factor.NTSB SEA95LA149Accident · No injuriesLimited investigationFinal reportEdwin J. Estenson RV-4 · Elk River, IDThe pilot failed to maintain directional control. The tall vegetation was a factor.NTSB NYC95LA160Accident · Serious injuriesLimited investigationFinal reportRaven S-60A · Deerfield, MAThe pilot's inadequate evaluation of the weather, which resulted in an encounter with unfavorable winds and an inflight loss of control. The unfavorable/high winds and sudden wind gusts were related factors.NTSB LAX95LA254Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Big Bear City, CAThe pilot's improper planning/decision and failure to obtain or maintain adequate airspeed during takeoff. A factor relating to the accident was: the high density altitude.NTSB FTW95LA305Accident · No injuriesLimited investigationFinal reportSchweizer SGS 126B · Durango, COInaccurate weather evaluation by the pilot-in-command. A factor was the lack of suitable terrain for a forced landing.NTSB FTW95LA304Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Stratton, COThe pilot's excessive rate of descent as he initiated the swath run and operation of the aircraft over the maximum allowable gross weight.NTSB FTW95LA299Accident · Serious injuriesLimited investigationFinal reportSlingsby T-51 · Odessa, TXThe pilot's failure to maintain airspeed required for flight, resulting in an inadvertent stall/spin at low altitude. A factor was the windshear.NTSB FTW95LA298Accident · 1 fatalLimited investigationFinal reportBradley Dragonfly · Silver City, NMPilot incapacitation due to a heart attack.NTSB FTW95FA300Accident · Serious injuriesField investigationFinal reportBeech C35 · Plano, TXFuel starvation due to the improper position of the fuel selector, and failure the pilot to follow emergency procedures.NTSB CHI95LA224Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Springfield, MOThe collapse of the left main landing gear for an undetermined reason.NTSB CHI95LA223Accident · No injuriesLimited investigationFinal reportCessna 182C · Derby, KSthe pilot's improper use of the powerplant controls, which resulted in a rough running engine and partial loss of engine power.NTSB CHI95FA226Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Festus, MOan improper annual inspection, the fouled spark plugs, the arcing magneto distributor, and the pilot's attempt to take off with known deficiencies.NTSB ATL95LA137Accident · Serious injuriesLimited investigationFinal reportCessna 172D · Stanton, TNThe pilot's failure to properly plan enough fuel for the intended flight which resulted in fuel exhaustion. Factors related to the accident were: the pilot became lost/disorientated, and high vegetation in the emergency landing area.NTSB ATL95LA136Accident · No injuriesLimited investigationFinal reportCessna 150F · Russellville, ALThe student pilot's failure to properly plan enough fuel for the solo cross country flight. A factor was the terrain.NTSB ATL95LA135Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Statesville, NCA cracked cylinder that resulted in a loss of engine power.NTSB ATL95LA134Accident · Minor injuriesLimited investigationFinal reportStafford Aerosport Scamp · Abbeville, SCThe improper engine overhaul which resulted in metal contamination of the engine assembly.NTSB ANC95FA104Accident · 2 fatalField investigationFinal reportCessna 172A · Naknek, AKInadequate visual lookout by the pilot of the Piper PA-18. The PA-18 pilot's diverted attention was a related factor.NTSB SEA95LA152Accident · No injuriesLimited investigationFinal reportBotteron Q-2 · Arlington, WAThe nonpilot-rated mechanic's impairment of judgment and performance due to alcohol; improper decision by the mechanic (unqualified person) to flight check the airplane; and fuel exhaustion after takeoff, due to an inadequate supply of fuel.NTSB CHI95LA222Accident · No injuriesLimited investigationFinal reportHughes 269C · Crete, NEthe pilot's failure to maintain clearance with the runway marker.NTSB CHI95LA221Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18A Dromader · Clinton, MOthe pilot's not using the flight manual and not understanding the fuel management for this particular airplane. Factors were the fuel system vent partial blockage and information unclear (phraseology) for the fuel management valve.NTSB CHI95LA220Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Cedar Rapids, IAthe pilot's lack of experience in flying from the right seat. A factor was the steep final approach.NTSB ANC95LA103Accident · No injuriesLimited investigationFinal reportde Havilland DHC-3 · Ketchikan, AKThe cracks in the trailing edge of the elevator servo tab, which resulted in its subsequent failure and partial separation.NTSB SEA95LA155Accident · No injuriesLimited investigationFinal reportCessna 172P · Vashon, WAThe loss of engine power due to connecting rod bolt overload failure. The rough, uneven terrain in the emergency landing area was a factor.NTSB NYC95LA161Accident · Minor injuriesLimited investigationFinal reportCessna 305A · Warren, VTa failed elevator cable which resulted in an inflight loss of control and uncontrolled contact with trees.NTSB NYC95LA158Accident · No injuriesLimited investigationFinal reportCessna 152 · Beaver Falls, PAthe failure of the student pilot to maintain directional control after touchdown.NTSB MIA95LA184Accident · Minor injuriesLimited investigationFinal reportCessna T188C · Ruleville, MSThe pilot-in-command's failure to abort the takeoff when the aircraft accelerated slowly. Contributing to the accident was the over loading of the aircraft by ground personnel and the failure of the pilot-in-command to verify the loading of the aircraft.NTSB MIA95LA182Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Goodman, MSThe pilot's failure to maintain flying airspeed which resulted in an aerodynamic stall.NTSB MIA95FA183Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Hilton Head Isl, SCloss of engine power for undetermined reasons, and the unsuitable terrain encountered during the emergency landing. A factor in the accident was the pilot's extension of the downwind leg which prevented landing on the intended runway following loss of engine…NTSB LAX95LA251Accident · No injuriesLimited investigationFinal reportMooney M-20-M · Santa Monica, CAthe pilot's improper remedial action during an aborted takeoff due to an improperly installed pitot line to the airspeed indicator.NTSB LAX95LA250Accident · No injuriesLimited investigationFinal reportCessna 170 · Columbia, CAthe pilot's selection of the wrong runway for the existing wind conditions; his inadequate compensation for the resulting crosswind situation; and his failure to maintain directional control of the aircraft.NTSB LAX95FA249Accident · 2 fatalField investigationFinal reportBeech A-36 · Hanford, CAUndetermined.NTSB FTW95LA297Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Osceola, ARThe loss of engine power due to a failed supercharger/blower. A factor was the lack of suitable terrain for a forced landing.