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 LAX89LA222Accident · 2 fatalLimited investigationFinal reportAmerican AA-1C · Kalaupapa, HIThe pilot's failure to maintain sufficient airspeed to prevent a stall from which there was insufficient altitude to recover.NTSB LAX89LA213Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · El Cajon, CAThe inadequate maintenance of the airplane & inadequate preflight inspection which resulted in the undetection of contaminated fuel.NTSB DEN89FA141Accident · 1 fatalField investigationFinal reportBeech A36 · South Lake Taho, CAThe pilot's falure to maintain adequate airspeed after takeoff due to diverted attention toward an open acft door.NTSB CHI89DEM03Accident · 2 fatalFinal reportBeneteau Steen Skybolt · Elk Rapids, MIThe pilot's failure to maintain aircraft control while attempting an aerobatic maneuver. Factors related to the were: inadequate altitude and lack of total experience in type of aircraft.NTSB BFO89LA046Accident · No injuriesLimited investigationFinal reportCessna 210A · Ocean City, MDFailure of the pilot to go around after landing long & recovering from a bounced landing. Contributing factors were: the pilot's excessive airspeed on the apch, his improper flare for the landing, his failure to attain the proper touchdown point, and the…NTSB ANC89LA101Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Alder Creek, AKSelection of unsuitable terrain (unimproved strip) by the pilot. Soft/uneven terrain & low bushes on the strip, as well as alders beside the strip, were contributing factors.NTSB ANC89LA097Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Sheshalik, AKPilot-in-command's failure to perform an adequate preflight inspection of the airplane's brakes.NTSB ANC89LA096Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Rainbow Lake, AKPilot in command's failure to maintain an airspeed (angle of attack) that would preclude a stall.NTSB NYC89LA150Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Niagara Falls, NYEngine failure due to oil starvation and collision with terrain during the forced landing. The oil starvation was caused by the oil leaking out of the drain because maintenance personnel failed to install the drain plug.NTSB MKC89LA137Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Clayton, KSThe failure of the pilot to compensate for the unfavorable wind conditions.NTSB MIA89FA177Accident · 1 fatalField investigationFinal reportUhley-Mason R.A.F. VARI-EZE · Lantana, FLPilots inadvertent turning off of the engine ignition switches resulting in engine failure.NTSB LAX89LA221Accident · No injuriesLimited investigationFinal reportCessna 172E · Grass Valley, CAFailure to perform maintenance inspections prescribed by the magneto, engine and aircraft manufacturers. The high density altitude and terrain conditions were contributing factors.NTSB DEN89LA140Accident · No injuriesLimited investigationFinal reportSchweizer 1-26E · Elbert, COThe pilot's improper inflight planning which placed the aircraft too FAR from the runway to complete a normal landing.NTSB CHI89LA116Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Port Huron, MIImproper in-flight planning/decision by the student pilot and his inadvertent encounter with wake turbulence from the transport aircraft. The student's lack of total experience was considered a contributing factor.NTSB CHI89LA115Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Michigan City, INFailure of the pilot to obtain and/or maintain adequate airspeed during takeoff, which resulted in an inadvertent stall & collision with the ground. Related factors were: failure of the pilot to follow procedures/directives and his operation of the aircraft…NTSB CHI89FA113Accident · 1 fatalField investigationFinal reportCessna 150L · Wisc Rapids, WIThe pilot's failure to assure that the flaps were in the up position during takeoff. A factor related to the accident was the pilot's lack of familiarity with aircraft.NTSB CHI89FA112Accident · Minor injuriesField investigationFinal reportHughes 269C · Lockport, ILImproper flight technique by the PIC during a takeoff from a confined area.NTSB CHI89DEK01Accident · Serious injuriesFinal reportPiper PA-28 · Albany, OHSeizure of the #4 exhaust valve and bending of its respective push rod, which resulted in a significant loss of engine power. Contributing factors were: lack of a suitable emergency landing area, trees, and the fence.NTSB CHI89DEI01Accident · No injuriesFinal reportCox/Pitts Special S-1S · Alliance, OHFailure of the pilot to maintain proper runway alignment. The soft terrain was a related factor.NTSB MKC89FA136Accident · 1 fatalField investigationFinal reportNorth American AT-6D · Earle, ARThe pilot's improper planning/decision and over confidence in his flying ability, which resulted in a loss of control, while maneuvering at low altitude. The pilot's inadequate altitude and airpeed were considered to be contributing factors.NTSB LAX89LA220Accident · No injuriesLimited investigationFinal reportCommonwealth 185 · Sacramento, CAFuel exhaustion due to the pilot's failure to accurately determine the fuel load prior to departure.NTSB LAX89LA219Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Banning, CAInadequate preflight planning/preparation by the pilot.NTSB LAX89LA218Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Trinity Center, CAAn interruption of fuel to the engine for undetermined reasons.NTSB LAX89LA217Accident · Minor injuriesLimited investigationFinal reportCessna 421 · Picacho, AZFailure of the number three exhaust valve on the left engine. A major factor was the high density altitude where the airplane would not operate on single engine.NTSB LAX89LA216Accident · No injuriesLimited investigationFinal reportCessna 175K · Bagdad, AZTotal loss of engine power due to undetermined reasons.NTSB LAX89LA215Accident · No injuriesLimited investigationFinal reportCessna 182P · Fallbrook, CAPilot did not follow procedures/directives in as much as he pushed the throttle forward too fast and the engine was not able to respond.NTSB DEN89LA139Accident · Minor injuriesLimited investigationFinal reportCessna 180K · Bullfrog, UTThe pilot failed to compensate for wind conditions during the landing roll. The crosswind was considered as a contributing factor. An underlying factor to the accident was the pilot's lack of experience in performing crosswind landings in the Cessna 180.NTSB CHI89LA111Accident · No injuriesLimited investigationFinal reportBoeing E75 · Shelbyville, INThe pilot allowed his attention to be devaited, misjudged altitude and distance to the runway while on final approach, and failed to maintain clearance above the power lines. Contributing factors were: the power lines and parked aircraft.NTSB CHI89LA110Accident · No injuriesLimited investigationFinal reportMaule MX-7-235 · Indianapolis, INImproper compensation for wind conditions by the pilot, his failure to maintain runway alignment, and his misjudgement of wingtip clearance above the ground as he was maneuvering to avoid the runway & VASI lights. The crosswind and runway/vasi lights were…NTSB CHI89FA114Accident · 2 fatalField investigationFinal reportMcculloch J-2 · Oxford, OHThe failure of the pilot operator to replace the main rotor thrust bearing. The expired service life of the main rotor thrust bearing is a factor in the accident.NTSB BFO89LA045Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Moundsville, WVThe pilot failed to maintian directional control and obstacle clearance while hovering at low altitude. A tail rotor blade struck an obstacle causing an overload separation failure of the blade.NTSB ATL89LA162Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Knoxville, TNThe pilot's failure to recognize that the engine was not developing full power and the delay in performing remedial action until it was too late to stop the airplane on the runway.NTSB ATL89FA163Accident · 1 fatalField investigationFinal reportCessna 172F · Vernon, ALImproper maintenance of the spark plugs by the pilot/mechanic which resulted in a partial loss of engine power, and the pilot's failure to clear trees during an emergency landing in an open field resulting in an inadvertent stall.NTSB MIA89LA175Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Miramar, FLInadequate planning/decision by the pilot, which resulted in loss of engine power due to fuel exhaustion. A contributing factor was the faulty reading from the fuel quantity indicator.NTSB LAX89LA223Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Herlong, CAFuel starvation, after the pilot diverted his attention to an electrical problem, and his failure to reposition the fuel selector switch, either before the engine lost power or during emergency procedures. Factors related to the accident were: the tripped…NTSB LAX89LA214Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · San Diego, CAFuel starvation due to the pilot's inadvertent selection of the off position on the fuel selector.NTSB FTW89DRD08Accident · Minor injuriesFinal reportSchweizer G-164B · Kaplan, LALoss of engine power due to a cracked cylinder.NTSB DEN89LA138Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Las Cruces, NMFailure of the left main landing gear trunnion. A contributing factor was: inadequate inspection procedure in Piper service bulletin #787A.NTSB CHI89FA109Accident · No injuriesField investigationFinal reportPiper PA-28R-200 · Saint Charles, ILThe failure of the mechanic to properly inspect the alternate air door during annual inspection. This failure led to air starvation, loss of power, and a forced landing by the pilot onto rough terrain.NTSB ATL89LA170Accident · No injuriesLimited investigationFinal reportCessna R172E · Birmingham, ALImproper flare by the pilot, which resulted in a hard landing. The fact that the pilot was asked twice to expedite the landing created pressure on the pilot and was considered to be a factor.NTSB ATL89FA161Accident · Serious injuriesField investigationFinal reportLockheed L1011-385-1 · Jacks Creek, TNFailure of the passengers to remain seated with their seat belts fastened as the airplane encountered unforecast severe clear air turbulence.NTSB ANC89LA093Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Eek, AKFailure of the center torque link bolt on the right main gear.NTSB ANC89FA094Accident · 4 fatalField investigationFinal reportPiper PA-22 · Kenai, AKInadequate preflight by the pilot and fuel exhaustion.NTSB MKC89LA134Accident · No injuriesLimited investigationFinal reportGrumman G164 · Brinkley, ARThe failure of the aircraft engine due to water contamination. The pilot executed a landing in a flooded rice field which did not permit a successful landing.NTSB MKC89FA135Accident · 1 fatalField investigationFinal reportCessna A185F · Ely, MNLoss of engine power for an undetermined reason. A factor related to the accident was: the presence of trees in the emergency landing area.NTSB MIA89FA176Accident · 1 fatalField investigationFinal reportBoeing A-75 · Daytona Beach, FLThe biplane pilot failed to see and avoid the collision with the banner being towed by the other airplane.NTSB FTW89DRD07Accident · No injuriesFinal reportGrumman-Schweizer G-164A · Morse, LALoss of engine power for an undetermined reason. The soft terrain was a contributing factor.NTSB DEN89LA163Accident · No injuriesLimited investigationFinal reportCessna A188B · Fort Benton, MTFailure of the tailwheel assembly attaching bolts.NTSB ATL89FA160Accident · Minor injuriesField investigationFinal reportGrumman American AA-5 · Columbus, OHThe student pilot's improperly planned approach, and inadequate supervision by the instructor pilot (CFI), which led to an encounter with wake turbulence and a loss of aircraft control.NTSB ANC89FA092Accident · 1 fatalField investigationFinal reportAerospatiale AS350B · Puntilla Lake, AKThe pilot continued VFR flight into instrument meteorological conditions (IMC) and failed to maintain sufficient altitude to clear the mountainous terrain. The weather and terrain conditions were contributing factors.