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.

NTSB CHI98LA250Accident · Minor injuriesLimited investigationFinal reportCanadian Car & Foundry Harvard MK IV · Dyersville, IAthe pilot in command's not maintaining control of the airplane and his inadvertently allowing the airplane to enter a stall. A factor was the undetermined loss of engine power.Jul 14, 1998 · N5101W · Substantial damageNTSB CHI98LA249Accident · No injuriesLimited investigationFinal reportCessna 190 · Pontiac, MIimproper procedures used during the replacement of the landing gear which resulted in pitting and corrosion of the gear spring.Jul 14, 1998 · N56W · Substantial damageNTSB ANC98LA097Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Nenana, AKThe failure of the FAA Flight Service Station specialist to issue an active Notice to Airmen that noted a hazardous condition on the runway. Factors associated with the accident are the rough and uneven runway, and inadequate runway maintenance by airport…Jul 14, 1998 · N8698N · Substantial damageNTSB ANC98LA095Accident · No injuriesLimited investigationFinal reportPiper PA-22 · North Pole, AKThe pilot's selection of unsuitable runway terrain for takeoff, and his failure to maintain directional control of the airplane. Factors in the accident were uneven/rutted terrain, and high vegetation along the runway edge.Jul 14, 1998 · N1724P · Substantial damageNTSB SEA98LA136Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Great Falls, MTThe pilot-in-command's improper remedial action and overload of the nose landing gear. Contributing factors were gusty winds and a pilot-induced oscillation (porpoise).Jul 13, 1998 · CGDBT · Substantial damageNTSB SEA98LA134Accident · Minor injuriesLimited investigationFinal reportNelson Cygnet SF-2A · Newberg, ORThe pilot-in-command's failure to maintain directional control. Factors contributing were the pilot-in-command's lack of experience in make of aircraft (i.e., use of toe brakes) and the fence post.Jul 13, 1998 · N191LM · Substantial damageNTSB SEA98LA133Accident · No injuriesLimited investigationFinal reportBeech 23 · Oakville, WALoss of power due to the failure of an exhaust valve, and overloading of the landing gear. Factors include the failure of maintenance personnel to verify proper compliance with an Airworthiness Directive related to the exhaust valve, and soft terrain.Jul 13, 1998 · N8719M · Substantial damageNTSB SEA98LA121Accident · No injuriesLimited investigationFinal reportCessna 172L · Lapwai, IDThe pilot's inadequate preflight planning or preparation from unsuitable terrain. Factors include an embedded railroad tie in the takeoff path, and high vegetation..Jul 13, 1998 · N2885Q · Substantial damageNTSB LAX98LA234Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Discus A · Bridgeport, CAThe failure of the pilot to maintain clearance with the trees while maneuvering to locate a thermal lift.Jul 13, 1998 · N95KM · DestroyedNTSB IAD98LA100Accident · No injuriesLimited investigationFinal reportCessna 172L · Lincoln Park, NJInadequate visual lookout by the pilot, which resulted in his failure to see and avoid the fuel truck. Related factors were the truck and the pilot was unfamiliar with that area.Jul 13, 1998 · N19667 · Substantial damageNTSB IAD98LA077Accident · Minor injuriesLimited investigationFinal reportBennett Piel Emeraude · Hillsville, VAA blocked fuel strainer due to an inadequate maintenance inspection by the previous owner, which resulted in fuel starvation.Jul 13, 1998 · N86WB · Substantial damageNTSB CHI98LA247Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Nehawka, NEthe pilot's improper fuel management and his improper use of the fuel tank selector. Factors were fuel starvation and crops.Jul 13, 1998 · N3770A · Substantial damageNTSB SEA98LA132Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5B · Chico Hot Sprgs, MTThe pilot-in-command's selection of the wrong runway for takeoff. Factors contributing to the accident were high density altitude, rising terrain and a fence post.Jul 12, 1998 · N28299 · Substantial damageNTSB SEA98LA131Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Hailey, IDThe pilot-in-command's failure to maintain directional control during takeoff. Contributing factors were the pilot-in-command's failure to follow procedures by the improper use of the flaps, high density altitude conditions, crosswind conditions and the tree.Jul 12, 1998 · N3018A · DestroyedNTSB LAX98LA230Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Hyampom, CAInadequate annual inspection that resulted in a partial loss of engine power due to a missing bolt, nut, and cotter pin from the throttle/carburetor assembly.Jul 12, 1998 · N6248R · Substantial damageNTSB LAX98FA219Accident · Minor injuriesField investigationFinal reportCessna 150 · Apple Valley, CAThe improper installation of unvented fuel caps that resulted in fuel starvation and loss of engine power. A factor was the lack of suitable terrain for a forced landing.Jul 12, 1998 · N1706Q · Substantial damageNTSB FTW98LA297Accident · No injuriesLimited investigationFinal reportPeebles/Lancair 360 LC-20 · Price, UTThe pilot's excessive descent rate on final approach and his delayed use of power to arrest the excessive descent rate.Jul 12, 1998 · N360P · Substantial damageNTSB CHI98LA268Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Indianapolis, INthe delayed in-flight decision of the pilot in command to take control of the aircraft and the proper airspeed not obtained/maintained by the pilot in command which resulted in a stall. A factor to the accident was the runway light.Jul 12, 1998 · N17901 · Substantial damageNTSB CHI98LA251Accident · No injuriesLimited investigationFinal reportGrumman G-164B · New Haven, ILWater contamination of the fuel system. A related factor was the swampy terrain.Jul 12, 1998 · N6731K · Substantial damageNTSB CHI98LA248Accident · Serious injuriesLimited investigationFinal reportForney 415-C · Laurie, MOthe jammed aileron and elevator controls for undetermined reasons.Jul 12, 1998 · N99294 · DestroyedNTSB CHI98FA244Accident · 1 fatalField investigationFinal reportStubbe-Kitfox Classic · Traer, IAthe failure of the pilot of the Kitfox to maintain flying speed (Vs).Jul 12, 1998 · N494S · 2 aircraft · DestroyedNTSB SEA98LA130Accident · No injuriesLimited investigationFinal reportPerson Vari EZE · Arlington, WAA lack of adequate carburetor heat available and overload of the main landing gear. Contributing factors were carburetor icing conditions and soft terrain.Jul 11, 1998 · N29NS · Substantial damageNTSB LAX98LA228Accident · Serious injuriesLimited investigationFinal reportPitts S1-S · Tracy, CAThe failure of the pilot to maintain adequate clearance with the terrain during aerobatic maneuvering.Jul 11, 1998 · N71HR · Substantial damageNTSB LAX98LA227Accident · No injuriesLimited investigationFinal reportde Havilland DH-82A · Sedona, AZThe failure of the pilot to maintain a visual clearance with the trees.Jul 11, 1998 · N5050C · Substantial damageNTSB IAD98LA114Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Hammonton, NJImproper maintenance, which resulted in an over-pressurized landing gear.Jul 11, 1998 · N49CC · Substantial damageNTSB FTW98LA309Accident · Serious injuriesLimited investigationFinal reportOverton Mustang M-II · Hillsdale, WYThe pilot's inadequate visual lookout and his failure to maintain adequate clearance from obstacles. Factors were an intentional low altitude flight maneuver, wires, and low light conditions.Jul 11, 1998 · N121GD · Substantial damageNTSB FTW98FA307Accident · Serious injuriesField investigationFinal reportCessna 172N · Lincoln, TXThe #3 cylinder exhaust valve rocker arm fulcrum retaining stud backing out of its stud-tapped hole due to the improper tapping of the stud hole by unknown maintenance personnel. Contributing factors were the transmission wire, sign and gasoline pump.Jul 11, 1998 · N5632E · DestroyedNTSB CHI98LA271Accident · Minor injuriesLimited investigationFinal reportVollmers Sonerai II L · Lincoln, NDLoss of engine power due to a corroded ignition wire. Related factors were the tailwind, and ditch.Jul 11, 1998 · N317WM · Substantial damageNTSB CHI98LA245Accident · No injuriesLimited investigationFinal reportCessna 188B · Atlanta, NEA loss of engine power due to a loose 'B' nut on the fuel line fitting. Contributing to the accident was the inadequate maintain and the soft terrain.Jul 11, 1998 · N9247R · Substantial damageNTSB ANC98LA094Accident · Minor injuriesLimited investigationFinal reportMeeuwsen Wagabond · Wasilla, AKLoss of engine power for undetermined reasons.Jul 11, 1998 · N36GM · Substantial damageNTSB NYC98LA142Accident · No injuriesLimited investigationFinal reportCessna 180 · Wadsworth, OHA loss of engine power for undetermined reasons.Jul 10, 1998 · N180DR · Substantial damageNTSB FTW98FA306Accident · 2 fatalField investigationFinal reportBell 47G · Jones, OKThe pilot's failure to maintain adequate clearance from the trees during a low altitude flight/maneuver.Jul 10, 1998 · N12085 · DestroyedNTSB DCA98WA078Accident · No injuriesForeign investigationMolino MU2-2B-25 · Sao Paulo, BrazilJul 10, 1998 · PTLTC · Substantial damageNTSB CHI98LA246Accident · No injuriesLimited investigationFinal reportCessna 182L · Mackinac Island, MIThe pilot's failure to attain a stabilized approach and a touchdown point. The factors contributing to the accident were the pilot in command's improper use of flaps and his not performing a go-around. An additional factor was the pilot in command not using…Jul 10, 1998 · N42184 · Substantial damageNTSB ATL98LA096Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Vero Beach, FLThe pilot's improper flare which resulted in a hard landing.Jul 10, 1998 · N1493H · Substantial damageNTSB ANC98LA092Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKThe pilot's failure to maintain the proper glide path to the intended landing area and his failure to maintain flying airspeed resulting in a stall.Jul 10, 1998 · N1364P · Substantial damageNTSB SEA98LA128Accident · 1 fatalLimited investigationFinal reportHughes 369D · Raymond, WAThe use of the improper long-line cable by the ground crew, and its subsequent separation from the helicopter.Jul 9, 1998 · N5063G · No damageNTSB SEA98LA125Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Pasco, WASeparation of the throttle linkage which resulted in the loss of power. Factors include worn throttle linkage parts and the furrows in the plowed field which was the available field for the forced landing.Jul 9, 1998 · N4996X · Substantial damageNTSB MIA98IA195Incident · Minor injuriesIncident investigationFinal reportAirbus Industrie A-300B4-605R · San Juan, PRAn in-flight engine fire resulting from (1) the failure of the engine overhaul facility to install, and the failure of American Airlines to ensure installation of, the proper adapter bolt inserts to preclude fuel leakage and the failure of the engine overhaul…Jul 9, 1998 · N80057 · Minor damageNTSB IAD98LA078Accident · Serious injuriesLimited investigationFinal reportMastopietro Rans S12 · Phillips, MELoss of engine power due to a separated oil line. A related factor was the unsuitable field.Jul 9, 1998 · N6191V · Substantial damageNTSB FTW98LA305Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · San Angelo, TXThe loss of engine power as a result of fuel starvation due to the pilot's improper positioning of the fuel selector. A factor was the lack of suitable terrain for the forced landing.Jul 9, 1998 · N1279C · Substantial damageNTSB DCA98WA066Incident · No injuriesForeign investigationAirbus Industrie A300 · London, United KingdomJul 9, 1998 · N70072 · Minor damageNTSB CHI98LA243Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Minto, NDthe pilot's selection of unsuitable terrain for takeoff. Factors were wet and soft runway conditions, and a ditch and the end of the overrun area.Jul 9, 1998 · N9185C · Substantial damageNTSB ATL98LA095Accident · No injuriesLimited investigationFinal reportCessna 150M · Vero Beach, FLThe failure of the pilot to obtain flying speed, and the delayed decision to abort the take-off, leading to a loss of control in flight, and the subsequent collision with a ditch.Jul 9, 1998 · N9363U · Substantial damageNTSB ANC98LA093Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKThe pilot's failure to identify an unsafe/hazardous condition. A related factor was the ditch.Jul 9, 1998 · N1602A · Substantial damageNTSB MIA98WA194Accident · 4 fatalForeign investigationBeech BE58 · Belize City, BelizeJul 8, 1998 · N9025V · DestroyedNTSB FTW98LA304Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Plainview, TXThe pilot's failure to maintain obstacle clearance during the aerial application flight. A factor was the transmission wire.Jul 8, 1998 · N2325G · Substantial damageNTSB SEA98LA129Accident · No injuriesLimited investigationFinal reportCessna 150 · Oregon City, ORThe pilot's improper flare.Jul 7, 1998 · N6417T · Substantial damageNTSB SEA98LA126Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Aurora, ORDirectional control was not maintained by the pilot in command. Factors include rough terrain and hidden obstructions.Jul 7, 1998 · N2646A · Substantial damageNTSB SEA98LA124Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Eltopia, WAFatigue of the control rotor blade spar and failure of the maintenance inspector to follow the procedures set forth in the airworthiness directive.Jul 7, 1998 · N5360V · Destroyed