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 ATL96LA131Accident · No injuriesLimited investigationFinal reportBeech A23 · Tarboro, NCfatigue failure of the propeller blade. Factors relating to the accident were: corrosion pit(s) on the propeller blade, and inadequate maintenance/inspection of the propeller.NTSB SEA96LA216Accident · 1 fatalLimited investigationFinal reportPiper PA-18 · Gillette, WYfailure of the pilot to see-and-avoid the obstruction (power line). The powerline was a related factor.NTSB LAX96LA345Accident · No injuriesLimited investigationFinal reportCessna 172F · Ehrenberg, AZThe pilot's attempt to perform a low altitude evasive maneuver with inadequate airspeed resulting in a stall/mush.NTSB FTW96LA392Accident · Minor injuriesLimited investigationFinal reportBeech H35 · Boulder, COa loss of engine power due to a plugged fuel tank vent which resulted in fuel starvation. A factor was the lack of suitable terrain for the forced landing.NTSB FTW96FA390Accident · 1 fatalField investigationFinal reportCessna 320C · Waco, TXVFR flight by the pilot into instrument meteorological conditions, and his failure to maintain sufficient altitude or clearance from the terrain. Factors relating to the accident were: inadequate preflight by the pilot, his failure to obtain a weather…NTSB CHI96FA342Accident · Serious injuriesField investigationFinal reportGrumman F9F-2 · Kalamazoo, MIThe overrun of the runway as a result of the pilot's misjudgment of speed and distance because of an unreliable airspeed indication; reason for the unreliable airspeed indication was undetermined. Contributing to the accident was the pilot's perception of a…NTSB ATL96LA129Accident · Minor injuriesLimited investigationFinal reportBell 47G-4A (Soloy) · Belmont, MSfailure of the aft universal joint of the tail rotor drive shaft, due to inadequate lubrication by company maintenance personnel. A factor relating to the accident was the pilot's delay in discontinuing the flight after noting a progressively worse tail rotor…NTSB ATL96LA128Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Georgetown, SCfailure of maintenance personnel to comply with an airworthiness directive, requiring periodic magneto inspections; inadequate annual inspection of the airplane by (other) maintenance personnel; and subsequent failure of the impulse coupling in the left…NTSB LAX96LA338Accident · No injuriesLimited investigationFinal reportCessna 152 · Fresno, CAA separation of a connecting rod due to a lack of internal lubrication from a blocked oil passage after a bearing had shifted on its journal.NTSB FTW96LA391Accident · Serious injuriesLimited investigationFinal reportTubb AIR Commander 532 · Magnolia, ARThe loss of engine power due to the loss of coolant, as a result of a leak in the radiator. A factor was the lack of suitable terrain for the forced landing.NTSB FTW96IA389Incident · Minor injuriesIncident investigationFinal reportAirbus Industrie AE 340-300 · San Antonio, TXturbulence, and failure of passengers to properly fasten their seat belts and properly hold lap children after the captain announced expected turbulence.NTSB IAD96LA148Accident · Minor injuriesLimited investigationFinal reportBellanca BL-26 · Bowling Green, KYthe pilot's improper fuel consumption calculations and fuel exhaustion, which resulted in loss of engine power and a forced landing. The lack of suitable terrain for a forced landing was a related factor.NTSB IAD96FA147Accident · No injuriesField investigationFinal reportShort Brothers SC7 · Findlay Twnshp, PAThe pilot's improper in-flight decision to continue to his destination when known en route delays were encountered which resulted in fuel exhaustion.NTSB FTW96LA388Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Ferriday, LAThe partial loss of engine power due to a cracked cylinder head. Factors were the oil leak which restricted the pilot's visual lookout and the lack of suitable terrain for the forced landing.NTSB CHI96LA352Accident · No injuriesLimited investigationFinal reportCessna 172RG · Aurora, ILundetermined.NTSB CHI96LA341Accident · No injuriesLimited investigationFinal reportCessna 152 · Lakeville, MNthe student pilot misjudged the landing flare which resulted in the hard landing.NTSB CHI96FA334Accident · 2 fatalField investigationFinal reportThocker RV-4 · Muncie, INwas the in-flight disconnection of the horizontal and vertical stabilizer forward attachments.NTSB ANC96LA160Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Kotzebue, AKThe pilot's selection of an unsuitable landing area. A factor in the accident was the soft terrain.NTSB NYC96WA191Accident · 1 fatalForeign investigationLake LA-4 · Azores, PortugalNTSB NYC96LA185Accident · No injuriesLimited investigationFinal reportCessna 182 · Stow, MAthe pilot's misjudgment of speed and distance during the landing, and his failure to go around while there was sufficient runway remaining, which resulted in a runway overrun and an encounter with a soft terrain at the edge of a pond. Wet grass on the runway…NTSB NYC96LA184Accident · No injuriesLimited investigationFinal reportCessna 172N · Shirley, NYthe pilot's prematurely retraction of flaps during the go-around, which resulted in settling (mushing) of the airplane and a collision with the ground.NTSB MIA96LA231Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-108 · Pensacola, FLloss of engine power during the initial climb due to contamination in the carburetor. Trees in the emergency landing area were a related factor.NTSB LAX96LA337Accident · No injuriesLimited investigationFinal reportCessna 152 · San Carlos, AZthe pilot's decision to attempt a takeoff with the runway lights inoperative, and his failure to maintain runway alignment during an aborted takeoff, after failure of the landing light. Factors relating to the accident were: darkness, inoperative runway…NTSB ATL96LA127Accident · Serious injuriesLimited investigationFinal reportBeech 33 · West Palm Beach, FLThe maintenance personnel failure to properly inspect the fuel system during the last annual inspection.NTSB ANC96LA157Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKthe pilot's improper planning/decision, which resulted in loss of engine power due to fuel exhaustion. A factor associated with the accident was: the erroneous (false) indication of the fuel sight tubes.NTSB IAD96LA146Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Westminster, MDthe pilot's misjudgement of his speed and distance, his failure to attain the proper touchdown point during the landing, and his delay in executing a go-around (aborted landing), which resulted in an overrun.NTSB ANC96LA155Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Skwentna, AKthe pilot's improper planning/decision. Related factors were: the terrain condition, unfavorable (lee-side) wind, and trees.NTSB SEA96LA215Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Arlington, WAinadequate visual lookout by the pilot of the Piper J3, and failure of the flight instructor in the Bellance to ensure that clearance was maintained from the other moving aircraft. Factors relating to the accident were: the inherent visual restrictions…NTSB SEA96FA214Accident · 1 fatalField investigationFinal reportMudry CAP 10B · Fairchild Afb, WAloss of control due to a jammed aileron pushpull tube, due to improper installation/routing of electrical wire bundles through the right aileron bellcrank mechanism by unknown person(s).NTSB CHI96LA340Accident · No injuriesLimited investigationFinal reportCessna 150 · Wonder Lake, ILa blocked exhaust pipe as a result of an inadequate weld repair to the muffler.NTSB CHI96LA339Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Highland, ILfailure of the Piper PA-25 tow pilot to see-and-avoid the Blanik L-23 glider. A factor relating to the accident was: neither aircraft was equipped with a communication radio.NTSB SEA96TA213Accident · No injuriesFinal reportBell 206B-3 · St Regis, MTfailure of the pilot to maintain clearance from electrical transmission lines. The proximity of transmission lines was a related factor.NTSB LAX96LA336Accident · No injuriesLimited investigationFinal reportPitts S-1S · Reno, NVThe pilot of N230MP inadequate visual lookout while landing on a runway occupied by another known aircraft. A factor in the accident was the procedure to allow simultaneous landings by aircraft on the same runway.NTSB LAX96LA333Accident · No injuriesLimited investigationFinal reportCessna 170B · Concord, CAThe pilot's failure to maintain directional control. The 40-degree crosswind component was a factor in this accident.NTSB FTW96LA386Accident · Minor injuriesLimited investigationFinal reportBell 206L-1/C-30P · Morgan City, LAThe loss of tail rotor control as result of a tail rotor blade strike by an undetermined object. A factor was the lack of suitable terrain for the forced landing.NTSB CHI96LA335Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Janesville, WIfuel exhaustion as a result of an inadequate preflight by the pilot in command.NTSB ANC96LA166Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Chitina, AKThe pilot's selection of an unsuitable landing site. A factor associated with the accident is the rough and uneven landing site.NTSB ANC96LA154Accident · Serious injuriesLimited investigationFinal reportBell 206B · Cantwell, AKthe pilot's continued VFR flight into instrument meteorological conditions (IMC). The terrain conditions, low ceiling, fog, and whiteout conditions were related factors.NTSB ANC96FA158Accident · 2 fatalField investigationFinal reportChampion 7EC · May Creek, AKfailure of the pilot to maintain adequate airspeed, while maneuvering and/or flying at low altitude, which resulted in a stall and collision with the terrain. A factor relating to the accident was: the pilot allowed the weight and balance (aft…NTSB FTW96LA387Accident · No injuriesLimited investigationFinal reportCessna 182Q · Fayetteville, ARThe pilot's failure to obtain the proper touchdown point on the runway. Factors were gust and the slick, mowed grass runway.NTSB FTW96LA385Accident · Minor injuriesLimited investigationFinal reportHiller UH12E · Hamburg, ARThe loss of tail rotor control as result of a tail rotor blade strike by a partially disconnected ballast weight, due to a disconnected pin. A factor was the lack of suitable terrain for the forced landing.NTSB CHI96LA336Accident · Serious injuriesLimited investigationFinal reportKenoyer Horizon ONE · Owosso, MIthe pilot's failure to maintain aircraft control and airspeed. A factor was the pilot's lack of experience in type of aircraft.NTSB ATL96LA126Accident · No injuriesLimited investigationFinal reportCessna 177 · Lyon, MSthe student pilot's failure to maintain directional control of the airplane during a touch-and-go landing, which resulted in a ground swerve. The gusty crosswind condition was a related factor.NTSB SEA96LA212Accident · 1 fatalLimited investigationFinal reportGrazier Quickie 2 · Superior, MTloss of engine power after takeoff for undetermined reason(s), and failure of the pilot to maintain adequate airspeed, while maneuvering to return to the departure airport, which resulted in a stall and collision with wooded terrain.NTSB IAD96LA145Accident · Serious injuriesLimited investigationFinal reportDickmann Pitts S-1 · Meriden, CTfailure of the pilot to maintain control of the airplane during take off.NTSB FTW96LA384Accident · No injuriesLimited investigationFinal reportCessna 177RG · Colorado Sprngs, COThe improper installation of the propeller governor by company maintenance personnel, resulting in the total loss of oil and engine seizure. Factors were the pilot's misjudgment of altitude and airspeed, causing him to make a forced landing on unsuitable…NTSB MIA96FA229Accident · 1 fatalField investigationFinal reportAero Commander 680E · Lakeland, FLfailure of the pilot to maintain minimum control speed, while returning to the airport for a precautionary landing, following a reported loss of power in one engine, which resulted in a loss of aircraft control and an uncontrolled collision with the terrain.…NTSB LAX96LA332Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lancaster, CAfailure of the student pilot to maintain direction control of the airplane, which resulted in an inadvertent ground swerve and subsequent collapse of the nose gear, during an encountered with soft terrain.NTSB FTW96TA383Accident · No injuriesFinal reportBell 47G-3B-1 · Rangely, COthe pilot's excessive cyclic control input during a low altitude operation, and his failure to maintain altitude/clearance from high vegetation (sage brush). The proximity of high vegetation was a related factor.NTSB FTW96LA380Accident · Serious injuriesLimited investigationFinal reportBell UH-1H · Leadville, COThe pilot's improper inflight planning/decision in that he used an inadequate airspeed or an inadequate altitude, or both, for the intentional autorotation.