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 MIA89LA160Accident · No injuriesLimited investigationFinal reportBoeing E75N1 · Fort Lauderdale, FLFailure of the pilot to maintain directional control which resulted in an inadvertent ground swerve. The crosswind and the pilot's improper use of brakes were contributing factors.NTSB MIA89LA159Accident · 2 fatalLimited investigationFinal reportMooney M20J · Big Pine Key, FLThe pilot became spatially disoriented and was unable to maintain control of the aircraft. The light conditions (dark night) and weather (haze) were considered to be contributing factors.NTSB LAX89LA205Accident · No injuriesLimited investigationFinal reportCessna 190 · Livermore, CAThe failure of the flight instructor to maintain directional control. Contributing to the accident was the flight instructors lack of experience in this type aircraft.NTSB LAX89LA204Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Concord, CAStudent pilot had not attained compensation for the crosswind, and lost control of the airplane.NTSB LAX89DUG04Accident · Serious injuriesFinal reportHolman/Sears HS-1 · Rialto, CAFailure of the pilot to maintain sufficient airspeed, while turning after takeoff, which resulted in a stall/spin. Contributing factors were: improper planning/decision by the pilot by test flying an airplane that he was not properly certificated to operate,…NTSB FTW89LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Crosbyton, TXThe pilot's judgement of altitude and distance while on an approach to land. Factors related to the accident were: the high wind, transmission line, and airport fuel tank.NTSB FTW89LA101Accident · No injuriesLimited investigationFinal reportCessna 206D · Saint Jo, TXThe pilot's decision to attempt to takeoff from a field that was not suitable for such purpose.NTSB CHI89LA100Accident · No injuriesLimited investigationFinal reportCessna P206B · New Hudson, MIPilot's inadequate preflight which resulted in an engine failure due to water contamination of the fuel system. The wires, trees, and utility pole were related factors.NTSB CHI89LA097Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Necedah, WIPilot-in-command's improper use of the fuel selector.NTSB ATL89LA152Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Indian Trail, NCThe pilot's delay in aborting the landing after a bounced landing. Contributing factors were: improper flare by the pilot and the transmissions lines.NTSB SEA89LA096Accident · No injuriesLimited investigationFinal reportSchweizer G-164 · Hermiston, ORFailure and separation of the left main landing wheel.NTSB MKC89LA115Accident · No injuriesLimited investigationFinal reportCessna 180 · Duluth, MNThe failure of the pilot to maintain control of the aircraft while attempting to land in turbulent gusty wind conditions.NTSB MKC89LA114Accident · No injuriesLimited investigationFinal reportCessna 188 · Table Rock, NEThe catastrophic failure of the internal engine components due to oil starvation. Contributing to the severity of the accident was the rough terrain the pilot was forced to land on.NTSB MKC89FA116Accident · 2 fatalField investigationFinal reportBeech D55 · Greenwood, INInadequate preflight and improper use of the fuel system, which resulted in fuel starvation, and improper use of emergency procedures. Factors related to the accident were: self induced pressure by the pilot to meet an arrival time, his failure to extend the…NTSB MIA89LA157Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Arcola, MSThe circumferential on the number 2 cylinder which resulted in a loss of engine power.NTSB MIA89IA156Incident · No injuriesIncident investigationFinal reportTemco GC-1B · Crestview, FLFailure of the pilots to maintain directional control of the aircraft. Contributing to the incident was the crosswind and lack of brakes avialable to the pilot-in-command (PIC).NTSB MIA89GA155Accident · 2 fatalFinal reportCessna 172P · Davie, FLFailure of the pilot in command to maintain adequate airplane control while entering an area of turbulence caused by wild fires on the ground beneath his flight path.NTSB MIA89FA158Accident · 1 fatalField investigationFinal reportBryan Zenith CH-300 · Niceville, FLPilots incapacitation by a heart attack resulting in the airplane descending out of control and colliding with trees.NTSB FTW89LA105Accident · No injuriesLimited investigationFinal reportCessna 172 · Addison, TXFailure of the pilot to maintain clearance from the telephone pole. Factors related to the accident were: darkness, the pilot's disorientation, lack of visual perception at night, the telephone (utility) pole, and the ditch.NTSB FTW89LA104Accident · No injuriesLimited investigationFinal reportBell 47D-1 · Ardmore, OKThe flight instructor failed to recognize that the aircraft was developing a dangerous sink rate during the autorotation and take corrective action by executing a power recovery. Contributing to the accident were the gusty wind conditions.NTSB LAX89FA203Accident · 1 fatalField investigationFinal reportBell 206B · Camp Verde, AZFailure of the pilot to maintain adequate altitude to clear obstructions in his flight path and visually detect obstructions in order to avert a collision.NTSB MKC89LA113Accident · Minor injuriesLimited investigationFinal reportAmerican AA5-B · Valentine, NEThe pilot delayed initiating a go-around after not attaining a proper touchdown point during the approach to land. Contributing factors were the high density altitude and the trees off the departure end of the runway.NTSB MIA89FA154Accident · Minor injuriesField investigationFinal reportCessna 152 · Fort Pierce, FLFailure of the student pilot to maintain airspeed which resulted in an inadvertent stall. Contributing factors were: the weather conditions (smoke & haze), the student becoming lost, her lack of total experience, and her inability to understand ATC…NTSB LAX89LA186Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Phoenix, AZThe failure of the pilot to maintain adequate clearance behind the B-737 which resulted in the inadvertent encounter with wake turbulence.NTSB LAX89FA211Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Dinsmore, CAThe pilot's intentional VFR flight into instrument meteorological conditions, and his failure to maintain adequate terrain clearance. Contributing factors to the accident were: the pilot's failure to obtain weather information, his overconfidence in his…NTSB FTW89LA099Accident · No injuriesLimited investigationFinal reportBeech A36TC · Amarillo, TXFailure to attain liftoff speed and the pilot in command's failure to abort the takeoff.NTSB FTW89LA098Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Edmond, OKImproper maintenance performed by the company mechanic who failed to tighten the oil sump plug, and also failed to safety it.NTSB DEN89LA133Accident · No injuriesLimited investigationFinal reportCessna 182RG · Englewood, COFailure of the pilot to follow warnings provided by a NOTAM & flags on the taxiway. Factors related to the accident were: darkness and the ditch.NTSB DEN89IA124Incident · No injuriesIncident investigationFinal reportBoeing 727-247 · Denver, COFailure of the left main landing gear forward trunnion bearing support fitting due to a crack initiating at the forward edge of the bore and propagating by intergranular stress corrosion into the bore surface that resulted in an eventual ductile fracture.NTSB MIA89LA152Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Okeechobee, FLThe pilot's poor preflight preparation when he failed to recheck weather conditions after he delayed takeoff because of thunderstroms. Also, the pilot's poor inflight decision to land off-airport rather than return to the departure airport.NTSB MIA89IA153Incident · No injuriesIncident investigationFinal reportBoeing 727-100 · Guantanamo, PRFailure of the pilot in command to properly compensate for a crosswind condition, and failure to utilize the proper crosswind landing technique.NTSB LAX89LA202Accident · 1 fatalLimited investigationFinal reportAyres S2R · Atlantic Ocean (Atlantic Ocean)The pilot's continued flight from VMC to IMC, with icing conditions, from which recovery was not successful.NTSB FTW89DRD04Accident · No injuriesFinal reportSchweizer G-164A · Oak Grove, LAThe pilot failed to perform adequate prelight planning/preparation before attempting a takeoff by failing to assure the runway condition.NTSB FTW89DRD03Accident · 1 fatalFinal reportSchweizer G-164A · Maxie, LAFailure of the pilot to maintain clearance from the trees. A factor related to the accident was: the presence of trees near the field where fertilizer was to be dispensed.NTSB DEN89DTK01Accident · 1 fatalFinal reportPiper PA-36-300 · Agar, SDThe pilot's failure to maintain an adequate clearance with the powerlines. The powerline is considered to be a contributing factor to the accident.NTSB ATL89LA151Accident · No injuriesLimited investigationFinal reportRockwell 114 · Dayton, OHThe pilot's improper compensation for wind conditions and inadequate airspeed which resulted in an inadvertent stall after lift-off. The wind conditions and the pilot's lack of familiarity with the acft were contributing factors.NTSB ATL89DKJ04Accident · 2 fatalFinal reportGlassair III · Auburn, ALThe pilot's premature lift-off which resulted in a stall into trees.NTSB ANC89LA077Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Green Island, AKFailure of the pilot to select a suitable landing area. Factors related to the accident were: rough water conditions, and the pilot's lack of experience in this make and model of aircraft.NTSB ANC89FA076Accident · Minor injuriesField investigationFinal reportCessna 170B · Birchwood, AKFailure of the pilot to assure that the fuel selector was in the proper detent for takeoff. A factor related to the accident was: the soft/muddy terrain conditions in the emergency landing area.NTSB FTW89FA096Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Boise City, OKAn inadvertent stall resulting from the pilot's failure to maintain control of the aircraft and to maintain sufficient airspeed. The dark night and adverse wind conditions were contributing factors.NTSB CHI89MA095Accident · 3 fatalMajor investigationFinal reportDouglas DC3C-S13CG · Waterman, ILThe pilot-in-command (PIC) failed to provide adequate supervision while training the copilot and allowed the aircraft to enter a stall/spin, then did not provide adequate remedial action to properly recover from the spin. Factors related to the accident were:…NTSB CHI89DEP05Accident · Minor injuriesFinal reportPiper PA-25-235 · Suring, WIImproper planning/decision by the pilot, which resulted in fuel exhaustion and loss of engine power due to an inadequate supply of fuel. Factors related to th accident were: the lack of suitable terrain and trees in the emergency landing area.NTSB CHI89DEP04Accident · No injuriesFinal reportHiller UH-12E · Waterford, WIThe pilot's inability to maintain control during an autorotational landing attempt following the failure of the main rotor drive train torsional coupling.NTSB CHI89DEE03Accident · 2 fatalFinal reportRuschke Starduster TOO · Mc Henry, ILThe flying pilots failure to maintain airspeed during an ostentatious display resulting in an inadvertent stall and subsequent collision with terrain.NTSB BFO89FA033Accident · 2 fatalField investigationFinal reportBell UH-1B · Oldtown, MDFailure of the pilot to see-and-avoid the obstruction (inadequate visual lookout). Factors related to the accident were: the obstruction (static wires), and the lack of visual cues for the pilot to detect the wires.NTSB ATL89DKJ03Accident · No injuriesFinal reportGrumman G-164A · Loxley, ALThe loss of engine power due to carburetor ice, and the pilot's improper use of carburetor heat.NTSB ANC89FA075Accident · No injuriesField investigationFinal reportCessna 180J · Anchorage, AKPilot-in-command's poor judgement, and his lack of initial training (none) in seaplane operations.NTSB SEA89LA091Accident · Minor injuriesLimited investigationFinal reportPazmany PL-4A · Concrete, WAAn improper low pass and clearance with trees misjudged by pilot.NTSB SEA89LA090Accident · No injuriesLimited investigationFinal reportStits SA-3A · Jackpot, NVInadequate wind compensation by the pilot. Contributing to the accident were gusty grosswinds.NTSB NYC89LA140Accident · Serious injuriesLimited investigationFinal reportNorth American Navion A · North Creek, NYThe pilot's inadequate preflight planning/preparation for the takeoff.