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 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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).NTSB 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.NTSB 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.NTSB 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..NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB CHI98LA251Accident · No injuriesLimited investigationFinal reportGrumman G-164B · New Haven, ILWater contamination of the fuel system. A related factor was the swampy terrain.NTSB CHI98LA248Accident · Serious injuriesLimited investigationFinal reportForney 415-C · Laurie, MOthe jammed aileron and elevator controls for undetermined reasons.NTSB CHI98FA244Accident · 1 fatalField investigationFinal reportStubbe-Kitfox Classic · Traer, IAthe failure of the pilot of the Kitfox to maintain flying speed (Vs).NTSB 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.NTSB LAX98LA228Accident · Serious injuriesLimited investigationFinal reportPitts S1-S · Tracy, CAThe failure of the pilot to maintain adequate clearance with the terrain during aerobatic maneuvering.NTSB LAX98LA227Accident · No injuriesLimited investigationFinal reportde Havilland DH-82A · Sedona, AZThe failure of the pilot to maintain a visual clearance with the trees.NTSB IAD98LA114Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Hammonton, NJImproper maintenance, which resulted in an over-pressurized landing gear.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB ANC98LA094Accident · Minor injuriesLimited investigationFinal reportMeeuwsen Wagabond · Wasilla, AKLoss of engine power for undetermined reasons.NTSB NYC98LA142Accident · No injuriesLimited investigationFinal reportCessna 180 · Wadsworth, OHA loss of engine power for undetermined reasons.NTSB FTW98FA306Accident · 2 fatalField investigationFinal reportBell 47G · Jones, OKThe pilot's failure to maintain adequate clearance from the trees during a low altitude flight/maneuver.NTSB DCA98WA078Accident · No injuriesForeign investigationMolino MU2-2B-25 · Sao Paulo, BrazilNTSB 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…NTSB ATL98LA096Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Vero Beach, FLThe pilot's improper flare which resulted in a hard landing.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB DCA98WA066Incident · No injuriesForeign investigationAirbus Industrie A300 · London, United KingdomNTSB 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.NTSB 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.NTSB ANC98LA093Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKThe pilot's failure to identify an unsafe/hazardous condition. A related factor was the ditch.NTSB MIA98WA194Accident · 4 fatalForeign investigationBeech BE58 · Belize City, BelizeNTSB 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.NTSB SEA98LA129Accident · No injuriesLimited investigationFinal reportCessna 150 · Oregon City, ORThe pilot's improper flare.NTSB 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.NTSB 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.