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 FTW99LA218Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Ferriday, LAThe pilot's failure to refuel the airplane which resulted in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB DEN99LA144Accident · No injuriesLimited investigationFinal reportColeman Lancair IV P · Aspen, COA failure of the right landing gear's brake system. Factors were the improper touchdown point attained by the pilot, the existing weather conditions that included a tailwind and high density altitude, and the rocky ditch.NTSB ANC99LA111Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Talkeetna, AKThe pilot's selection of unsuitable terrain for landing. A factor was high vegetation in the landing area.NTSB NYC99LA196Accident · No injuriesLimited investigationFinal reportCessna 172P · Montgomery, NYthe failure of the student pilot to maintain directional control during the touchdown and landing roll.NTSB MIA99LA223Accident · 1 fatalLimited investigationFinal reportArnet Pereyra Aero Aventura II · Rockledge, FLThe pilot's failure to attain directional control during his attempted takeoff due to his exceeding the airplane's gross weight limit for takeoff and the resultant inflight collision with a building.NTSB LAX99LA267Accident · 1 fatalLimited investigationFinal reportCessna 152 · Agana, TaiwanThe loss or partial loss of engine power for undetermined reasons.NTSB DEN99LA149Accident · No injuriesLimited investigationFinal reportAir Tractor AT-402A · Mead, COThe pilot's failure to follow proper approach to landing procedures as outlined in the Airplane Flight Manual. A factor was the 6-foot tall corn stalks.NTSB DEN99LA143Accident · No injuriesLimited investigationFinal reportMoore Q-200 · Cortez, COThe pilot's improper recovery from a bounced landing and his failure to maintain directional control. Related factors were the soft wet terrain.NTSB DEN99IA154Incident · No injuriesIncident investigationFinal reportBalloon Works Firefly 9 · Hartsel, COTotal failure of the deflation line due to heat damage (as evidenced by glazing), most likely caused by the improper use of the flight controls (burner system) by person(s) unknown.NTSB CHI99LA291Accident · No injuriesLimited investigationFinal reportCessna 182 · Tecumseh, MIfracture of the right main landing gear strut.NTSB CHI99LA287Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Garden City, KSThe pilot's misjudging his pull-up maneuver resulting in contact with the wire. A contributing factor was the wire.NTSB ANC99LA117Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Skwentna, AKThe pilot's selection of unsuitable terrain for landing. A factor was high vegetation.NTSB SEA99LA137Accident · No injuriesLimited investigationFinal reportCessna 180J · Council, IDThe pilot's inadequate recovery from a bounced landing. Gusting wind conditions and a dirt bank adjacent to the runway edge were factors.NTSB SEA99FA138Accident · Serious injuriesField investigationFinal reportBeech H-35 · Swan Lake, MTDetonation/pre-ignition due to use of improper grade and type of fuel (automotive) and the pilot-in-command's failure to use proper fuel specified by manufacturer's directives.NTSB NYC99LA195Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Chatham, MAThe pilot's improper flare and improper recovery from a bounced landing.NTSB MIA99LA228Accident · No injuriesLimited investigationFinal reportWilliam John Schulz WJS Jaybird · Tangerine, FLthe pilot's improper torqueing of a rocker arm adjusting jam nut, that resulted in the adjuster loosening, and a partial loss of engine power. This resulted in the pilot making an off airport precautionary landing and subsequent nose over, during which the…NTSB MIA99LA222Accident · No injuriesLimited investigationFinal reportCessna 152 · Lawrenceville, GAThe failure of the pilot to maintain directional control during takeoff from a touch and go landing resulting in the aircraft traveling off the runway, colliding with taxiway lights and a taxiway sign, collapsing the nose landing gear, and nosing down.NTSB LAX99FA266Accident · 1 fatalField investigationFinal reportCessna 177 · Boulder City, NVThe flight instructor's inadequate supervision of the flight and his failure to maintain an adequate airspeed and altitude margin while conducting low altitude maneuvers in an area of strong gusty winds and terrain-induced turbulence likely to contain wind…NTSB FTW99RA217Accident · 6 fatalForeign investigationCessna 414 · Monrovia, LiberiaNTSB FTW99LA215Accident · No injuriesLimited investigationFinal reportMbb BO-105S · Vermilion 250The failure of the pilot to maintain directional control of the helicopter while attempting to takeoff. A factor was the high wind condition.NTSB DEN99LA141Accident · No injuriesLimited investigationFinal reportCessna 152 · Salt Lake City, UTAn inadvertent collision with a bird.NTSB CHI99LA298Accident · No injuriesLimited investigationFinal reportBell 206L · Cape Girardeau, MOThe inadequate preflight planning/preparation by the pilot, in that the auxiliary power unit cord was not removed. The brick wall was a contributing factor.NTSB CHI99FA285Accident · 2 fatalField investigationFinal reportBell 206B · Custer, SDThe pilot's failure to maintain adequate altitude/clearance from the trees. Contributing to the accident was the pilot's inadvertent settling with power.NTSB SEA99LA139Accident · No injuriesLimited investigationFinal reportCessna 188B · Sidney, MTThe pilot's failure to adequately compensate for wind conditions.NTSB SEA99LA136Accident · Minor injuriesLimited investigationFinal reportCessna 182G · Freeland, WAThe pilot-in-command's improper use of carburetor heat and overload of the nose gear assembly during the forced landing. Contributing factors were carburetor icing conditions, the ditch and fence.NTSB MIA99LA218Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Greeneville, TNThe pilot's failure to remain clear of clouds while operating under visual flight rules resulting in the aircraft colliding with trees on rising terrain as he flew in the clouds.NTSB FTW99LA250Accident · No injuriesLimited investigationFinal reportCessna 177 · Austin, TXFuel exhaustion as a result of the pilot's failure to refuel the airplane.NTSB DEN99LA140Accident · No injuriesLimited investigationFinal reportPzl-Mielec M-18A · Hasty, COThe pilot's failure to refuel his airplane, and the subsequent airborne fuel exhaustion. Factors were the lack of suitable terrain for a forced landing, and the high vegetation in the field.NTSB CHI99LA286Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Evansville, INfuel exhaustion due to the flight instructor's improper in-flight decision. A factor was the ditch.NTSB CHI99LA281Accident · No injuriesLimited investigationFinal reportCessna 150M · Perry, IAthe student pilot's inadequate compensation for the wind conditions which resulted in her failure to maintain control of the airplane. A factor associated with the accident was the gusty crosswind condition.NTSB ANC99FA108Accident · 4 fatalField investigationFinal reportCessna A185F · Juneau, AKThe pilot's continued VFR flight into instrument meteorological conditions. Factors associated with the accident were mountainous/hilly terrain, low ceilings, the pilot's improper in-flight decision making, and the pilot's impairment from over-the-counter…NTSB SEA99FA168Accident · 1 fatalField investigationFinal reportSchweizer 269C · Westport, ORThe pilot's failure to maintain clearance from terrain. Factors include low clouds and visibility and near-night light conditions.NTSB NYC99LA228Accident · No injuriesLimited investigationFinal reportPiper PA-601P · West Dover, VTwas the diverted attention of the pilot, which resulted in his failure to maintain airspeed, and his failure to lower the landing gear prior to landing.NTSB NYC99FA193Accident · 2 fatalField investigationFinal reportPiper PA28R-180 · Seven Springs, PAThe pilot's failure to obtain a rate of climb after takeoff due to spatial disorientation. Factors in this accident were low ceilings, fog, and the pilot's lack experience in instrument meteorological conditions.NTSB MIA99LA221Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Greenville, SCThe improper position of the fuel selector by the pilot-in-command resulting in the loss of engine power due to fuel starvation. Also, the inadequate altitude flown by the pilot on final approach preventing a landing on the runway following the loss of engine…NTSB MIA99LA217Accident · No injuriesLimited investigationFinal reportBell 47G-B3 · Selma, ALThe pilot's failure to maintain the proper touchdown point during landing causing the landing skid to become entangled with the edge of the helipad platform and the resultant rollover and main rotor blade strike of the tow vehicle.NTSB MIA99LA216Accident · No injuriesLimited investigationFinal reportCessna 172R · Savannah, GAThe student pilot's failure to maintain directional control of the airplane during a touch-and-go landing, resulting in the airplane running off the runway and colliding with a runway sign.NTSB FTW99LA214Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Cypress, TXThe flight instructor's failure to maintain/obtain airspeed during takeoff climb, which resulted in an inadvertent stall/mush.NTSB FTW99LA213Accident · No injuriesLimited investigationFinal reportCessna 172N · Hot Springs, ARthe pilot's failure to refuel the airplane which resulted in fuel exhaustion and a total loss of engine power. A factor was the lack of suitable terrain for a forced landing.NTSB FTW99FA212Accident · 1 fatalField investigationFinal reportStanton Pitts S-1S · Coushatta, LAThe pilot's poor in-flight decision to perform aerobatics at a low altitude and slow airspeed, resulting in the inadvertent stall/spin.NTSB DEN99LA138Accident · No injuriesLimited investigationFinal reportCessna TU206A · Durango, COA worn landing nose gear steering system that diminished the ability to steer the airplane. Factors were improper maintenance by unknown persons, and loose gravel.NTSB DCA99WA072Accident · No injuriesForeign investigationMcDonnell Douglas MD-11 · Shanghai, ChinaNTSB CHI99LA297Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Oberlin, KSEngine failure due to an undertorqued carburetor fulcrum screw. Contributing factors were the muddy terrain and the low altitude of the aerial operation.NTSB CHI99LA279Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Schaumburg, ILthe CFI's delay in taking remedial action to maintain directional control of the airplane. A factor associated with the accident was the student's improper use of the brakes.NTSB CHI99FA284Accident · 1 fatalField investigationFinal reportBellanca 7GCAA · Titonka, IAThe low altitude maneuver attempted and altitude/clearance not being maintained by the pilot, which resulted in an impact with a pine tree. A factor to the accident was the pine tree.NTSB ANC99LA109Accident · No injuriesLimited investigationFinal reportCessna A188-B · Bettles, AKThe pilot's selection of unsuitable terrain for landing. A factor was soft terrain.NTSB MIA99LA220Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-10-10F · Memphis, TNThe inadequate design by the airplane manufacturer for using bolts to secure the inboard trailing edge flap that are susceptible to stress corrosion cracking. Also, the stress corrosion cracking failure of the four H-11 bolts that secure the left inboard…NTSB FTW99LA216Accident · No injuriesLimited investigationFinal reportCessna 172RG · Celina, TXThe failure of the pilot in command to use all of the available runway for takeoff.NTSB FTW99FA211Accident · 2 fatalField investigationFinal reportCessna 177 · Wagoner, OKThe pilot's inadvertent stall while performing an abrupt maneuver at low altitude.NTSB CHI99LA280Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Gainesville, MOthe inadequate preflight planning/preparation by the pilot and all available runway exceeded by the pilot. The trees and power lines were contributing factors.