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 SEA89FA160Accident · 4 fatalField investigationFinal reportCessna 152 · Snohomish, WAThe pilot's failure to see and avoid N49231, a Cessna 172. Contributing factors were: a flight path directly into the setting sun, and the low light conditions of dusk on the ground below.NTSB MKC89FA191Accident · 2 fatalField investigationFinal reportPiper PA-20 · Moose Lake, MNSevere corrosion of the lower forward lift strut for the right wing, inadequate inspection of the lift strut by maintenance personnel, and subsequent failure of the lift strut, which resulted in an overload failure (folding back) of the wing. Related factors…NTSB LAX89LA291Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Hemet, CAInadequate crew coordination between the tow pilot and glider pilot, failure of the glider pilot to obtain proper assistance, and the tow pilot's misunderstanding of the glider pilot's intentions.NTSB FTW89GA156Accident · Minor injuriesFinal reportPiper PA-18-150 · Grand Chenier, LAOn August 30, 1989, at 1225 CDT, a Piper PA-18-150, N4423Z,being operated by and conducting an aerial survey forlouisiana wildlife and fisheries commission as a publicaircraft, flipped forward to the inverted position during aforced landing 15 miles…NTSB DEN89LA203Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Dutch John, UTInadequate compensation for the wind conditions by the pilot, resulting in a loss of control during the takeoff ground run. Factors related to the accident were: the unfavorable (variable/gusty) wind condition, and the high vegetation and tree beside the…NTSB NYC89FA204Accident · 1 fatalField investigationFinal reportCessna U206F · West Point, NYContinued VFR flight by the pilot into an area of marginal visual meteorological conditions, and his failure to maintain sufficient altitude over mountainous/hilly terrain. Factors related to the accident were: dark night, high terrain, low clouds/ceiling,…NTSB MIA89FA237Accident · 1 fatalField investigationFinal reportEagle DW-1-220 · Oklawaha, FLThe loss of control on the ground during the landing roll for undetermined reasons.NTSB FTW89FA155Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Pauls Valley, OKImproper planning/decision by the pilot, his lack of understanding of the procedures for operating the aircraft, his improper use of the fuel selector in managing his fuel supply, fuel starvation, and the pilot's failure to know and follow the emergency…NTSB DEN89FA202Accident · 4 fatalField investigationFinal reportAerospatiale AS-350D · Blanchard, IDOverheating and seizure of the swashplate bearing, which resulted in an inflight breakup of the helicopter and subsequent impact with the ground.NTSB BFO89FA075Accident · 5 fatalField investigationFinal reportPiper PA-31-350 · Lynchburg, VAPilot's failure to maintain clearance from obstructions because of improper IFR operation. Contributing to the accident was descent below decision height, delay in initiating the missed approach, and fog conditions.NTSB SEA89LA158Accident · No injuriesLimited investigationFinal reportPiper PA-15 · Independence, ORFailure of the pilot to maintain directional control during the landing, which resulted in an inadvertent ground loop and subsequent overload failure of the left main gear. A factor related to the accident was: improper flare by the pilot.NTSB SEA89FA157Accident · 1 fatalField investigationFinal reportBeech C35 · Sandy, ORThe loss of engine power due to the separation of the bolt connecting the throttle rod to the carburetor throttle arm and an inadequate annual inspection performed 5 flight hours prior to the occurrence. Contributing factors were obstructions in and around…NTSB MKC89LA189Accident · No injuriesLimited investigationFinal reportConsolidated-Vultee BT-13A · Kansas City, MOInadequate control tower service provided by tower personnel, and inadequate remedial action by the vehicle driver. The pilot's lack of visual lookout was considered to be a contributing factor.NTSB MIA89LA236Accident · Minor injuriesLimited investigationFinal reportCessna 188A · Milton, FLFlight in known adverse weather by the pilot. Turbulence from the nearby thunderstorm was a related factor.NTSB MIA89LA235Accident · No injuriesLimited investigationFinal reportCessna 172N · Madison, MSThe pilot's improper flare and improper recovery from a bounced landing, which resulted in porpoising of the aircraft and an uncontrolled ground swerve.NTSB LAX89WA293Accident · 1 fatalForeign investigationBeech BE-24 · Mexicali, MexicoNTSB FTW89LA154Accident · 1 fatalLimited investigationFinal reportCessna 150M · Hearne, TXThe failure of the pilot to maintain control of the airplane and his lack of experience/training. A factor was the pilot's poor physical condition.NTSB DEN89LA201Accident · No injuriesLimited investigationFinal reportWaco UPF7 · Watkins, COFailure of the left brake assembly, and subsequent loss of directional control by the pilot.NTSB DEN89FA200Accident · Serious injuriesField investigationFinal reportCessna 172 · Tremonton, UTThe pilot failed to maintain obstruction clearance while making a low pass over a newly constructed highway. The powerline was considered a contributing factor.NTSB CHI89LA176Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Eau Claire, WIInadvertent retraction of the landing gear by the pilot. His habit interference and lack of experience in the type of aircraft were contributing factors.NTSB CHI89DEM07Accident · Minor injuriesFinal reportBradley S-1D · Mt Pleasant, MIThe tail wheel spring becoming disconnected resulting in the pilot's inability to maintain directional control of the airplane.NTSB BFO89LA077Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-65 · Leonardtown, MDInadequate preflight planning/preparation by the pilot by not assuring that the acft was properly secured, or that someone was at the controls while he was hand propping the engine. A related factor was the pilot's improper adjustment of the throttle cable.NTSB BFO89FA074Accident · 2 fatalField investigationFinal reportBeech C50 · Hagerstown, MDThe pilot's failure to maintain control of the airplane as a result of spatial disorientation after intentionally flying into instrument flight conditions. Contributing to the accident was the pilot's over confidence in his ability and the obscured weather…NTSB ATL89LA204Accident · Serious injuriesLimited investigationFinal reportBeech A23-19 · Gallatin, TNThe pilot used an unsuitable runway area (terrain) for takeoff. Related factors were: inadequate maintenance of the runway, runway conditions (uneven surface & tall grass), and the fence.NTSB ANC89LA151Accident · No injuriesLimited investigationFinal reportMaule M-4-210 · Bainbridge, AKContinued flight by the pilot into known adverse weather conditions, and his subsequent selection of unsuitable terrain for landing. Factors related to the accident were: adverse weather conditions and terrain conditions in the precautionary landing area.NTSB SEA89LA159Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Atlanta, IDThe pilot's failue to adequately compensate for the downdraft conditions. Contributing factor(s) was: the downwind, downdraft, and high density altitude weather conditions, and the surrounding mountainous terrain.NTSB MKC89LA190Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Wabbaseka, ARImproper planning/decision by the pilot which resulted in his failure to maintain clearance from the tall vegetation (grass). The tall vegetation & high density altitude were considered to be contributing factors.NTSB MKC89LA188Accident · No injuriesLimited investigationFinal reportBell 206B · Park Rapids, MNThe pilot misjudged the clearance between the helicopter and the power line. The power line (transmission wire) was considered to be a contributing factor.NTSB MIA89LA234Accident · No injuriesLimited investigationFinal reportCessna 172N · Jacksonville, FLInadequate visual lookout by the pilot. Factors related to the accident were: dark night, light pole with an inoperative light, and the lack of visual perception concerning the pilot's ability to see the pole at night.NTSB LAX89LA290Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Columbia, CAThe pilot's improper recovery from a bounced landing and loss of directional control.NTSB LAX89LA289Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Tracy, CADual student's failure to properly flare the helicopter during the autorotation power recovery and the cfi's failure to adequately supervise the dual student's performace during a critical phase of flight.NTSB LAX89LA288Accident · Minor injuriesLimited investigationFinal reportRyan ST3KR · Hawthorne, CAOil starvation of the engine due to the pilot's failure to turn the oil tank supply valve on prior to flight.NTSB LAX89LA163Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Williams, AZFailure of the pilot to maintain his visual lookout and flying low. Contributing to the accident was the one inch diameter telephone cable.NTSB FTW89LA153Accident · Serious injuriesLimited investigationFinal reportCessna 150C · Jonesboro, LAThe pilot's improper flare, improper recovery from a bounced landing, and failure to maintain directional control, which resulted in a porpoise off the side of the runway. The tree was a related factor.NTSB CHI89DEI03Accident · Minor injuriesFinal reportBrumbaugh/Hubin Long EZE · West Salem, OHInadequate visual outlook and attention diversion by the pilot. Factor(s) related to the accident was: the presence of the wires.NTSB CHI89DEC06Accident · 1 fatalFinal reportFeil BD-5 · Pontiac, MIThe pilot's failure to maintain adequate airspeed during takeoff which resulted in a stall/spin. Contributing to the accident was the excessive pull-up maneuver and the pilot's lack of total experience in the aircraft.NTSB BFO89LA076Accident · No injuriesLimited investigationFinal reportCessna 150 · Gaithersburg, MDAn undetermined problem with the ignition system. A factor related to the accident was: the pilot's failure to properly secure the airplane or obtain proper assistance.NTSB ATL89LA203Accident · No injuriesLimited investigationFinal reportCessna 150G · Edgefield, SCPoor inflight planning by the pilot in command in that he allowed the fuel supply to be exhausted.NTSB NYC89LA202Accident · No injuriesLimited investigationFinal reportCessna 150H · Northeast, PAA power loss due to an over-rich engine for undetermined reasons. The combination of an over-rich running engine and the pilot's pumping of the throttle during the recovery attempt caused the engine to flood.NTSB NYC89LA200Accident · No injuriesLimited investigationFinal reportCessna 182F · Albany, NYThe pilot's improper flare during landing.NTSB NYC89LA199Accident · Serious injuriesLimited investigationFinal reportCessna A185F · Deer Isle, METhe pilot's inadequate preflight in determining the adequacy of the takeoff environment under the existing adverse wind conditions.NTSB MIA89LA232Accident · No injuriesLimited investigationFinal reportCessna A188B · Edwards, MSInadequate preflight by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. Rough terrain in the emergency landing area was a related factor.NTSB MIA89LA231Accident · Minor injuriesLimited investigationFinal reportHughes 269A · Jacksonville, FLInadequate visual look-out by the pilot and his failure to maintain control of the helicopter, while maneuvering to avoid obstructions. The transmission lines were considered to be factors.NTSB MIA89FA233Accident · 4 fatalField investigationFinal reportBeech C23 · Barranquitas, PRImproper in-flight planning/decision by the pilot and his failure to maintain adequate flying speed, which resulted in a stall and subsequent impact with the terrain. Contributing factors were: operation of the aircraft by the pilot with excessive gross…NTSB FTW89IA152Incident · No injuriesIncident investigationFinal reportBoeing 727-231 · Kenner, LAInaccurate operators procedures/directives and the improper takeoff performance data computed by the captain. Poor flight crew coordination was considered a factor as well a wrong runway selection for the computed takeoff data.NTSB BFO89LA073Accident · No injuriesLimited investigationFinal reportCessna 152 · Selbyville, DEExcessive wear of the number four exhaust lobe on the camshaft and poor condition (wear) of the number four exhaust tappet. The soybean crop in the emergency landing area was considered to be a factor.NTSB ATL89LA202Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Gainesville, GAThe pilot's misjudgement of the airplane fuel supply during preflight inspection, and his subsequent failure to monitor in-flight fuel consumption, which led to an engine power loss due to fuel exhaustion. Contributing to the accident were the pilot's…NTSB ANC89LA149Accident · Minor injuriesLimited investigationFinal reportMaule M-5-235C · Fairbanks, AKThe pilot was taxiing too fast to negotiate a bend in the river. Trees & the river bank were contributing factors.NTSB LAX89FA287Accident · 2 fatalField investigationFinal reportCessna 180J · Tracy, CAInadequate visual lookout by both pilots, which resulted in their failure to see-and-avoid each other's aircraft. A factor related to the accident was: the lack of a conflict alert system for the stockton arts ii radar.NTSB DEN89LA199Accident · Serious injuriesLimited investigationFinal reportCessna T210F · Englewood, COA failure in the hyrdraulic power unit, which prevented operation of either the normal or emergency gear extension systems. The raised runway lip contributed to aircraft damage and pilot injury.