NTSB investigations, 2001
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 WHERE year(c.\"eventDate\") = 2001 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 WHERE year(c."eventDate") = 2001 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 LAX01FA198Accident · 1 fatalField investigationFinal reportCessna 150L · Tulare, CAThe student's failure to maintain adequate airspeed during the crosswind climb that resulted in a stall/spin at low altitude and the airplane's subsequent ground impact. A factor was the student's failure to retract the wing flaps.NTSB IAD01WA065Accident · 1 fatalForeign investigationBell P-63A-7BE · Biggin Hill, United KingdomNTSB DEN01FA110Accident · 3 fatalField investigationFinal reportCessna T210G · Lyons, COThe pilot's inadequate preflight planning/preparation and his continued flight into adverse weather condition resulting in controlled flight into terrain. Contributing factors were the fog, low ceilings and the pilot's lack of recent experience.NTSB CHI01LA153Accident · No injuriesLimited investigationFinal reportRockwell 112TC · Cambridge, MNThe pilot's inadequate compensation for the wind conditions and the failure to maintain control of the airplane. A factor associated with the accident were the trees that the airplane contacted during the aborted landing.NTSB CHI01LA152Accident · No injuriesLimited investigationFinal reportAllen Rotorway 162F · Jerseyville, ILthe improper autorotation by the pilot. Contributing factors were the engine failure for undetermined reason(s) and the muddy terrain.NTSB CHI01LA151Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-402B · Mount Vernon, SDthe pilot not maintaining aircraft control while maneuvering close to the ground.NTSB ANC01LA067Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Minto, AKThe pilot's selection of unsuitable terrain for takeoff, and an excessive descent rate resulting in a hard landing during an aborted takeoff. Factors in the accident were a collision of the airplane's float assembly with an unknown object, and the pilot's…NTSB LAX01LA202Accident · No injuriesLimited investigationFinal reportBeech 76 · Prescott, AZThe certified flight instructor's inadequate supervision of the student who failed to maintain adequate airspeed on approach, resulting in a stall/mush, and delayed remedial action when the flight instructor ordered a go-around.NTSB LAX01LA197Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Cameron Park, CAthe pilot's failure to maintain an adequate clearance altitude from en route obstructions.NTSB IAD01LA062Accident · No injuriesLimited investigationFinal reportEaa Chapter 40 Cubby Sport Trainer · Elkton, MDThe Cubby pilot's inadequate visual lookout for the Bellanca on the runway, prior to landing.NTSB IAD01LA061Accident · Serious injuriesLimited investigationFinal reportStampe ET Renard SV-4 · Rhinebeck, NYThe pilot's failure to maintain climb, and his failure to maintain adequate airspeed.NTSB FTW01LA135Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Amarillo, TXthe pilot's inadequate compensation for the crosswind, which resulted in a hard landing. A contributing factor was the crosswind.NTSB ATL01LA086Accident · No injuriesLimited investigationFinal reportCessna R172-K · Culebras Island, PRPilots improper flare which resulted in a hard landing.NTSB ATL01LA063Accident · 2 fatalLimited investigationFinal reportAir Tractor 502B · Anguilla, MSFailure of both pilots to maintain visual lookout, resulting in an in-flight collision. A factor was sun glare.NTSB ANC01LA066Accident · No injuriesLimited investigationFinal reportHelio H-391B · Anvik, AKThe pilot's continued operation of the accident airplane with known equipment deficiencies, and an improper installation of the float assembly by maintenance personnel. A factor in the accident was the pilot's delay in aborting the takeoff.NTSB ANC01LA063Accident · No injuriesLimited investigationFinal reportCessna 180 · Fairbanks, AKThe pilot's failure to refuel the airplane, his inadequate preflight planning/decision making, and subsequent fuel exhaustion during cruise flight.NTSB WAS01WA017Accident · Serious injuriesForeign investigationCessna T188 · Los Rios, EcuadorNTSB SEA01WA108Accident · No injuriesForeign investigationCessna 150M · D'Arcy, CanadaNTSB SEA01LA111Accident · No injuriesLimited investigationFinal reportCessna TR182 · Boise, IDThe pilot's failure to adequately compensate for wind conditions. Wind gusts were a factor.NTSB SEA01LA110Accident · No injuriesLimited investigationFinal reportCessna 172M · Pingree, IDThe pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of engine power.NTSB DEN01LA109Accident · Serious injuriesLimited investigationFinal report2001 Mcgirl Questair Venture · Ogden, UTan in-flight fire, which originated from a fuel leak of unknown origin.NTSB DEN01LA107Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-180 · Albuquerque, NMthe pilot's diminished visual lookout, resulting in the wire strike. Contributing factors were the total mechanical failure of the cylinder, dusk, and the power transmission line.NTSB SEA01LA109Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Salem, ORLoss of engine power during cruise flight for an undetermined reason. A factor in the accident was tall grass in the landing area.NTSB SEA01IA113Incident · No injuriesIncident investigationFinal reportCessna 172S · Monroe, ORA degradation of aircraft control for undetermined reasons.NTSB NYC01LA135Accident · No injuriesLimited investigationFinal reportMusso Nieuport 24 · Evesham Twp., NJAn in-flight propeller failure, which resulted in a forced landing.NTSB MIA01LA150Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Fort Pierce, FLThe loss of engine power during takeoff/initial climb due to compressor turbine blade separation.NTSB LAX01LA196Accident · No injuriesLimited investigationFinal reportBell 47G-4A · Buttonwillow, CAThe pilot's inadequate in-flight planning that resulted in settling with power during an aerial application turn-to-reverse direction and collision with the ground. Factors were high density altitude and a wind shift.NTSB LAX01LA195Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164B · Butte City, CAa fatigue failure of a propeller bolt.NTSB ANC01LA061Accident · No injuriesLimited investigationFinal reportCessna 172 · Wasilla, AKAn undershoot due to the pilot's failure to maintain a proper glide path during a VFR final approach to landing. A factor in the accident was a downdraft.NTSB SEA01LA107Accident · No injuriesLimited investigationFinal reportHerriford RAF 2000 · Gardiner, MTthe pilot's failure to rotate the aircraft until he was well past the normal takeoff rotation speed, and his abrupt rotation at this higher speed.NTSB MIA01LA149Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Greensboro, NCthe pilot's failure to maintain airspeed during takeoff/initial climb, which resulted in an inadvertent stall, an uncontrolled descent, and collision with trees.NTSB MIA01LA148Accident · No injuriesLimited investigationFinal reportCessna A188B · Humboldt, TNthe pilot's failure to maintain directional control of the aircraft during the landing rollout, resulting in a ground loop/ground swerve and substantial damage to the aircraft.NTSB MIA01LA147Accident · No injuriesLimited investigationFinal reportRussell Heyn Rans S-6 · Swainsboro, GAthe failure of the pilot to properly compensate for a crosswind and for gusty conditions during takeoff/initial climb, which resulted in an inflight loss of control and collision with the ground.NTSB FTW01LA134Accident · No injuriesLimited investigationFinal reportCessna 182K · Victoria, TXthe pilot's inadequate preflight inspection which resulted in an unsecured seat which slipped aft on takeoff.NTSB DEN01LA106Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Elizabeth, COthe loss of engine power during approach for an undetermined reason. A contributing factor was the high density altitude.NTSB ANC01LA060Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Alexander, AKThe instructor pilot's inadequate supervision of the flight. Factors in the accident were the dual student's selection of unsuitable terrain for landing, and the presence of a sand bar in the landing area.NTSB NYC01LA130Accident · No injuriesLimited investigationFinal reportContinental Copters Tom Cat Mark 5A · Benton, PAThe pilot's inadequate preflight inspection, which resulted in a takeoff with a hose still attached and a subsequent dynamic rollover.NTSB DEN01FA111Accident · 4 fatalField investigationFinal reportPiper PA-28-161 · Meeker, COthe pilot's failure to maintain terrain clearance as a result of his drug induced impairment. A factor was his exceeding the airplane's gross weight limits.NTSB ATL01LA060Accident · No injuriesLimited investigationFinal reportCessna 421C · Greenville, MSThe improper installation by maintenance personnel of the push-pull rod assembly on the right elevator trim tab horn resulted in an in-flight separation of the right elevator trim tab.NTSB SEA01FA106Accident · 1 fatalField investigationFinal reportPiper PA-12 · Augusta, MTThe pilot's failure to maintain adequate airspeed after takeoff resulting in an inadvertent stall at low a altitude.NTSB NYC01LA131Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Fairfield, KYThe pilot's inadequate visual lookout during takeoff, and his inadequate reconnoiter of the area prior to takeoff.NTSB MIA01LA146Accident · Serious injuriesLimited investigationFinal reportBoeing 737-301 · Toccoa, GAAn in-flight encounter with unforecasted weather (turbulence) during an enroute climb resulting in one flight attendant sustaining serious injury.NTSB LAX01FA194Accident · 3 fatalField investigationFinal reportCessna 210A · Escondido, CAthe pilot's spatial disorientation and lack of instrument flight proficiency that resulted in a loss of directional control and the airplane's subsequent in-flight collision with the ground.NTSB FTW01LA131Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Georgetown, TXthe pilot's failure to refuel the aircraft resulting in fuel exhaustion during cruise flight. A contributing factor was the gusty wind encountered during the forced landing.NTSB DEN01LA103Accident · Minor injuriesLimited investigationFinal reportHall Lancair 4P · Bennett, COunsuitable terrain on which to make a forced landing. A contributing factor was a fatigue fracture of the starter adapter drive shaft, which resulted in a loss of engine power due to oil starvation.NTSB CHI01LA150Accident · Minor injuriesLimited investigationFinal reportPerth Amboy Bird CK · Casco Twp., MIThe engine failure due to carburetor ice. Factors associated with the accident were the carburetor icing conditions which existed and the tree which was contacted during the forced landing.NTSB CHI01FA146Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Osage Beach, MOAircraft control not being maintained by the pilot during the forced landing and inadequate preflight inspection performed by the pilot. Contributing factors to the accident were the fuel system contamination that resulted in the loss of engine power, the…NTSB SEA01LA105Accident · No injuriesLimited investigationFinal reportCessna T210M · Portland, ORA burst hydraulic line and consequent total loss of hydraulic fluid from the landing gear, which disabled landing gear operation.NTSB NYC01LA133Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Clinton, MDThe pilot's failure to maintain directional control during landing rollout. Factors related to the accident were the pilot's lack of experience in tail-wheeled airplanes, and the wind gusts.NTSB MIA01LA145Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Spartanburg, SCThe pilot's improper fuel management resulting in a total loss of engine power due to fuel exhaustion, forced landing, and subsequent in-flight collision with trees and terrain. Contributing to the accident was an unidentified pilot's failure to yield the…