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 MIA98LA092Accident · No injuriesLimited investigationFinal reportCessna 188B · Houston, MScorrosion and subsequent disconnect of the left aileron control rod end fitting, which resulted in a loss of aileron (roll) control, a forced landing, and subsequent impact with the terrain. A factor related to the accident was: improper lubrication of the…NTSB LAX98LA105Accident · No injuriesLimited investigationFinal reportLearjet 23 · Oakdale, CAfailure of the flight crew to extend the landing gear before landing.NTSB LAX98LA104Accident · Serious injuriesLimited investigationFinal reportBoeing 737-242C · Reno, NVUnforecasted and sudden encounter with clear air turbulence when passengers and flight attendants were not secured in their seats.NTSB IAD98LA034Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Haverhill, MAA loss of engine power due to a fractured number two cylinder exhaust valve and cracked cylinder. Contributing factors were the operator's allowance of the time between engine overhaul to be exceeded and the trees.NTSB CHI98LA100Accident · No injuriesLimited investigationFinal reportCessna 650 · Manistee, MIthe pilots excessive airspeed during landing, exceeding the proper touchdown point, and failure to execute a missed approach.NTSB SEA98FA042Accident · 6 fatalField investigationFinal reportCessna T303 · Midvale, IDThe pilot's failure to maintain aircraft control.NTSB LAX98LA102Accident · Minor injuriesLimited investigationFinal reportLawrence Kitfox · Cottonwood, AZThe pilot's failure to maintain directional control and attain the proper airspeed for takeoff. A factor in the accident was his lack of recent experience in the make and model of airplane.NTSB FTW98LA140Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Lake Village, ARThe pilot's use of unsuitable terrain for takeoff. A factor was the rough/uneven terrain.NTSB DCA98WA027Accident · No injuriesForeign investigationFokker F-100 · Mexico City, MexicoNTSB ANC98LA024Accident · No injuriesLimited investigationFinal reportCessna 180H · Tatitna, AKThe pilot's selection of unsuitable terrain for landing. A factor was the snow machine ruts creating a rough landing surface.NTSB MIA98WA097Accident · 5 fatalForeign investigationCessna 401 · La Puntilla, ChileNTSB LAX98LA101Accident · Minor injuriesLimited investigationFinal reportCessna 310C · Lancaster, CAThe pilot's improper use of the mixture controls.NTSB LAX98LA099Accident · No injuriesLimited investigationFinal reportSweet-House RD Mustang 2 · Madera, CAThe failure of the pilot to maintain adequate airspeed during the approach, which resulted in a stall. An additional cause was the pilot's failure to maintain directional control during the attempted go around. A factor in this accident is the pilot's lack of…NTSB NYC98FA071Accident · 2 fatalField investigationFinal reportPiper PA-31-310 · Presque Isle, METhe pilot's failure to follow the published instrument approach procedure and his descent below the minimum descent altitude. Contributing factors were the night conditions, low ceilings, and fog.NTSB LAX98LA100Accident · No injuriesLimited investigationFinal reportRyan PT22-ST3KR · Davis, CAThe failure of the pilot to maintain directional control of the aircraft on the landing roll.NTSB IAD98FA032Accident · 2 fatalField investigationFinal reportCessna 172P · Langley Afb, VAThe pilot's inadvertent VFR flight into IMC conditions, and the subsequent loss of aircraft control due to spatial disorientation. A factor in the accident was the low ceiling.NTSB FTW98LA141Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Rayville, LAThe pilot's inadequate compensation for the gusting crosswinds. Factors were the gusting crosswinds and the pilot's lack of experience in gusting crosswinds.NTSB FTW98LA137Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Marietta, OKThe pilot's improper compensation for the wind conditions. A factor was the crosswind.NTSB NYC98LA072Accident · No injuriesLimited investigationFinal reportMooney M20J · Avoca, PAa bird strike.NTSB NYC98LA069Accident · 1 fatalLimited investigationFinal reportPiper PA28R-180 · Walbridge, OHthe pilot's failure to refuel the aircraft resulting in fuel exhaustion, and his unsuccessful attempt to clear the wires. Contributing factors were the pilot's inadequate preflight, dark night conditions, and the wires.NTSB MIA98LA090Accident · Serious injuriesLimited investigationFinal reportCessna 337 · Raymond, MSthe pilot passenger's impairment of judgment and performance due to alcohol, and control interference by the pilot passenger, which resulted in a loss of aircraft control and subsequent in-flight collision with the runway and trees.NTSB IAD98LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Warrenton, VAThe student pilot's improper flare which resulted in a hard landing.NTSB NYC98LA070Accident · No injuriesLimited investigationFinal reportCessna 320F · Lincoln, METhe pilot's failure to maintain adequate altitude which resulted in left main landing gear contacting a snowbank during the landing approach.NTSB FTW98LA138Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Monroe, LAThe pilot's improper decision to continue the flight after noting the low fuel quantity indication, which resulted in the loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB FTW98LA135Accident · No injuriesLimited investigationFinal reportCessna 150G · Lonoke, ARthe flight instructor's selection of unsuitable terrain for takeoff, and his delayed decision to abort the takeoff. A factor relating to the accident was: the soft/wet area on the turf runway.NTSB FTW98LA134Accident · Minor injuriesLimited investigationFinal reportBurchinal A4D-2 · Fort Worth, TXA total hydraulic system failure for an undetermined reason.NTSB CHI98LA098Accident · Minor injuriesLimited investigationFinal reportCessna 402B · Mason City, IAthe accumulation of airframe ice during flight, and failure of the pilot to attain a proper flare for landing. Factors relating to the accident were: the adverse weather (icing) condition; and the pilot's limited forward visibility, due to ice on the…NTSB SEA98LA041Accident · No injuriesLimited investigationFinal reportCessna 175 · Port Townsend, WAThe pilot's misjudged distance and speed during landing. A factor was the wet grass runway.NTSB SEA98FA040Accident · 2 fatalField investigationFinal reportFreije Lancair IV · Garwood, IDThe pilot's failure to maintain aircraft control after entering known adverse weather. Related factors were, the pilot's failure to follow the published IFR departure procedures, low ceilings and snow, and the pilot's lack of recent instrument experience.NTSB MIA98LA088Accident · Serious injuriesLimited investigationFinal reportCessna 195 · Chapel Hill, NCfailure of the pilot to maintain directional control of the aircraft during a go-around, followed by his failure to maintain airspeed while maneuvering to avoid trees, which resulted in a stall and collision with the terrain. The pilot's lack of recent night…NTSB MIA98LA087Accident · No injuriesLimited investigationFinal reportCessna 150M · Daytona Beach, FLfailure of the flight instructor (CFI) to maintain adequate airspeed, during the final approach and flare to land, which resulted in an inadvertent stall/mush and allowed the wingtip to drag during touchdown.NTSB MIA98FA089Accident · No injuriesField investigationFinal reportFokker F28 MK 0100 · Birmingham, ALWere the 1) the inoperative alternate anti-skid control valve due to the disconnected electrical connector on the parking brake shut-off valve, the area was inspected 2 days earlier 2) the total loss of the hydraulic system resulting in the inability of the…NTSB LAX98LA103Accident · No injuriesLimited investigationFinal reportAir Tractor 301-300 · Woodland, CAThe failure of the pilot to adequately monitor his fuel consumption, which resulted in fuel exhaustion.NTSB LAX98FA098Accident · 1 fatalField investigationFinal reportRobinson R22 · Littlerock, CAThe pilot's improper use of the rotorcraft cyclic control in response to encountering terrain induced turbulence. A factor in the accident was the pilot's failure to obtain a preflight weather briefing which contained precautionary notices for turbulence.NTSB IAD98LA030Accident · No injuriesLimited investigationFinal reportCessna 172 · Rutland, VTthe pilot's improper in-flight planning/decision, which resulted in fuel exhaustion, loss of engine power, and a forced landing. Related factors were: unfavorable (headwind) conditions, and brush/small trees in the forced landing area.NTSB ANC98LA023Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Naknek, AKThe pilot's failure to maintain an adequate visual lookout. Factors in the accident were flat lighting conditions, and inadequate airport facilities.NTSB MIA98LA086Accident · Serious injuriesLimited investigationFinal reportLake LA-4-200 · Lake Murray, SCA collision with an unknown submerged.NTSB FTW98LA133Accident · No injuriesLimited investigationFinal reportCessna 172D · El Paso, TXThe pilots improper compensation for the wind conditions and his failure to maintain control of the aircraft. A factor was the high wind condition.NTSB DCA98WA026Accident · 2 fatalForeign investigationBell 212 · Mexico City, MexicoNTSB SEA98LA039Accident · No injuriesLimited investigationFinal reportCessna 150F · Fife, WAThe fracture separation of an exhaust valve head, followed by the total failure of the associated piston. A factor was the soft terrain at the location of the forced landing.NTSB MIA98LA085Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Holly Springs, MSa total loss of power due to fuel starvation as a result of the pilot's lack of adequate preflight planning and preparation and his failure to adequately refuel his airplane.NTSB MIA98LA084Accident · 1 fatalLimited investigationFinal reportWalter J Collie Cumulus · Hillsboro, TNDebonding of the leading edge to spar cap joint, which resulted in inflight separation.NTSB LAX98IA097Incident · No injuriesIncident investigationFinal reportBeech BE99 · Oakland, CAWater accumulation in the tail section of the aircraft that froze around the elevator control cables which restricted the movement of the elevator. Contributing factors were the accumulation of debris in the limbers and drain hole for the affected area. A…NTSB FTW98LA139Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Dallas, TXThe nose gear collapsed for an undetermined reason. A factor was the total electrical failure due to the separation of the alternator output lugs resulting from inadequate maintenance.NTSB ANC98LA025Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Kongiganak, AKThe pilot misjudged distance/altitude and airspeed, and his delay initiating a go-around. Related factors were the downdraft and snowbank.NTSB ANC98LA017Accident · No injuriesLimited investigationFinal reportCessna 185E · Anchorage, AKA separation of the axle from the landing gear strut due to overload, and stripping of the axle bolt threads.NTSB MIA98LA083Accident · No injuriesLimited investigationFinal reportCessna T210N · Covington, GAthe pilot's inadequate preflight planning/preparation and/or improper fuel management, which resulted in fuel exhaustion, loss of engine power, and a forced landing. Soft/wet terrain in the emergency landing area was a related factor.NTSB LAX98LA092Accident · No injuriesLimited investigationFinal reportSchempp-Hirth VENTUS-B · Williams, CAThe pilot's failure to maintain an adequate clearance from the oil drilling rig due to his attention being diverted inside the cockpit in order the secure the landing gear control.NTSB LAX98IA096Incident · No injuriesIncident investigationFinal reportBeech 100 · Reno, NVIce formation around the elevator control cables due to plugged limbers and a water drain hole.NTSB LAX98FA095Accident · 2 fatalField investigationFinal reportBeech A36 · San Gorgonio Mo, CAThe pilot's inability to maintain altitude due to an encounter with adverse winds and downdrafts on the lee side of a mountain. Also causal was the pilot's inadequate weather evaluation, which precipitated his intentional flight into an area of known adverse…