NTSB investigations, 2001
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 FTW01LA203Accident · 1 fatalLimited investigationFinal reportGrumman G-164B · Lydia, LAthe pilot's failure to maintain clearance with a marked tower while maneuvering.NTSB DEN01FA157Accident · 1 fatalField investigationFinal reportBoeing 777-236 · Denver, COthe overstress fracture of the airplane's refueling adapter ring that resulted from the abnormal angular force applied to it. The applied angular force occurred due to the ground refueler inadequately positioning the hydrant fuel truck (in relation to the…NTSB CHI01LA305Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Grand Forks, NDThe student pilot's improper flare, and the flight instructor's delayed remedial action, which resulted in a loss of directional control.NTSB ATL01WA107Accident · No injuriesForeign investigationBell TH-1F · Puerto Plata, Dominican RepublicNTSB ANC01LA148Accident · No injuriesLimited investigationFinal reportCessna 180 · Big Lake, AKA loss of engine power during cruise flight for an undertermined reason.NTSB ANC01LA133Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Tok, AKThe pilot's failure to abort the landing. Factors associated with the accident were the pilot's selection of an unsuitable landing area, and his failure to attain a proper touchdown point. An additional factor was a ditch.NTSB SEA01LA165Accident · No injuriesLimited investigationFinal reportCessna T210L · Olympia, WAThe inability of the landing gear to fully extend due to the failure of a hydraulic hose in the nose gear extension system.NTSB NYC01LA220Accident · No injuriesLimited investigationFinal reportAndre Mini Max 1500R · Chesapeake, VAThe pilot's failure to follow the engine manufacturer's descent procedure, which resulted in a lean mixture condition and subsequent engine seizure.NTSB MIA01LA226Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Daytona Beach, FLa total loss of engine power due to the pilot's improper procedures by not placing the fuel selector on the tank with the most fuel, after a reported restricted movement of the flight controls for undetermined reasons, which resulted in fuel starvation and a…NTSB FTW01LA202Accident · Minor injuriesLimited investigationFinal reportHiller UH-12D · Lubbock, TXthe failure of the tail rotor drive shaft hanger bearing, which resulted in the separation of the tail rotor drive shaft. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI01LA313Accident · Serious injuriesLimited investigationFinal reportGelasi Aircamper · Bloomfield, WIAircraft control not possible due to the inadvertent control interference by the front seat passenger. Factors to the accident were the restricted control stick movement and the encountered stall.NTSB CHI01LA310Accident · No injuriesLimited investigationFinal reportMooney M20K · Croswell, MIThe pilots failure to abort the takeoff. Factors were the pole and the trees.NTSB CHI01LA304Accident · No injuriesLimited investigationFinal reportBeech C23 · St. Helen, MIThe pilot's failure to attain the proper airspeed which resulted in a premature lift-off and subsequent stall/mush. A factor to the accident was the fence.NTSB CHI01LA300Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Atlantic, IAThe loss of engine power for undetermined reasons during the takeoff and initial climb, and the unsuitable terrain encountered during the forced landing. Factors relating to this accident were the corn crop and the low altitude.NTSB SEA01LA164Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Winston, ORThe pilot's failure to maintain clearance from a fence during the initial takeoff. A fence was a factor.NTSB NYC01LA222Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Warren, VTThe pilot's improper fuel planning, which resulted in fuel exhaustion.NTSB NYC01LA221Accident · No injuriesLimited investigationFinal reportde Havilland DHC-94 Moth Minor · Farmington, PAThe in-flight separation of a propeller blade, which resulted in a forced landing to unsuitable terrain. A factor related to the accident was the plowed field.NTSB LAX01LA301Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Bridgeport, CAThe failure of the pilot to maintain directional control of the tail wheel equipped aircraft during landing roll which resulted in a ground loop.NTSB LAX01LA299Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Carson City, NVThe pilot's incorrect setting of the fuel selector valve during the prelanding checklist to a position between usable tanks, resulting in fuel starvation.NTSB LAX01LA298Accident · No injuriesLimited investigationFinal reportSparke Air Command 582 Dual · Gerlach, NVThe pilot's inability to maintain altitude because of the gyrocopter's inadequatly designed performance capability.NTSB IAD01LA104Accident · No injuriesLimited investigationFinal reportCessna 172P · Augusta, METhe pilot's failure to maintain the proper distance from a sign post during taxi.NTSB IAD01LA103Accident · No injuriesLimited investigationFinal reportCessna U206G · Millersburg, OHThe pilot's misjudgment of speed and distance, which resulted in an overrun during landing. Factors were the short, wet, grass runway, and his failure to do a go-around.NTSB ENG01WA009Incident · No injuriesForeign investigationExtra Flugzeugbau 400 · Rorvik, NorwayNTSB DEN01LA158Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B-15 · Colo. Springs, COthe passenger's failure to follow instructions given to brace for a high wind landing, and the pilot's failure to adequately monitor the passenger's actions. A contributing factor was the thermal lift.NTSB DEN01LA154Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas 369E · Kemmerer, WYloss of tail rotor effectiveness while hovering. A contributing factor was the wind gust.NTSB CHI01LA306Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Pierre, SDThe pilot not maintaining directional control of the airplane during landing.NTSB ANC01LA136Accident · No injuriesLimited investigationFinal reportCessna 185F · King Salmon, AKAn overload failure of the main axle attaching bolts, and subsequent separation of the axle from the landing gear strut.NTSB LAX01FA297Accident · 1 fatalField investigationFinal reportCessna T210M · Watsonville, CAThe loss of engine power for undetermined reasons.NTSB CHI01LA303Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Sheldon, IAthe in-flight planning/decision and proper touchdown point not attained by the pilot. Contributing factors were the ingested exhaust valve and lack of experience of the pilot.NTSB CHI01LA301Accident · No injuriesLimited investigationFinal reportCessna 150L · Madison, WIThe deer which struck the empennage of the airplane during the landing flare.NTSB CHI01LA299Accident · No injuriesLimited investigationFinal reportBeech 58P · Theodosia, MODiminished braking action due to standing water on the runway. A factor associated with the accident was the ditch which the airplane contacted.NTSB ANC01LA141Accident · No injuriesLimited investigationFinal reportJacobs KE-1-A · Willow, AKA loss of engine power during cruise flight for an undertermined reason.NTSB ANC01LA131Accident · No injuriesLimited investigationFinal reportMaule M-7-235B · Koliganek, AKThe pilot's delay in aborting the takeoff. A factor in the accident was the pilot's diverted attention during the takeoff.NTSB SEA01MA163Accident · 3 fatalMajor investigationFinal reportKawasaki KV-107-II · Emigrant, MTThe loss of control during cruise/climb flight for undetermined reasons.NTSB LAX01LA296Accident · No injuriesLimited investigationFinal reportFunk C · Merced, CAThe pilot's improper modification of the airplane when he switched a nonvented fuel cap to the fuselage tank. A factor was the inadequate annual inspection.NTSB DEN01LA155Accident · No injuriesLimited investigationFinal reportVans RV-6A · Pagosa Springs, COThe pilot's inadequate airplane preflight inspection which led to the subsequent lateral control of the airplane on the ground not being possible. A contributing factor was the unavailability of rudder control due to a headset blocking the rudder control…NTSB CHI01FA298Accident · 1 fatalField investigationFinal reportSpears RV-6 · Grayslake, ILThe pilot inadvertently stalled the airplane. A factor was the impairment due to marihuana.NTSB ANC01LA132Accident · No injuriesLimited investigationFinal reportCessna 177RG · Fairbanks, AKThe pilot's failure to extend the landing gear.NTSB ANC01LA130Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Fairbanks, AKA failure of the pilot to maintain directional control of the airplane during the takeoff run.NTSB MIA01WA235Accident · Serious injuriesForeign investigationCessna 421 · Carcassome, FranceNTSB IAD01LA102Accident · Serious injuriesLimited investigationFinal reportEmbraer ERJ-135ER · Richmond, VAInadequate company procedures/directives, which resulted in the flight attendant leaving her seat prematurely, while the airplane was still in an area of turbulence.NTSB CHI01LA307Accident · No injuriesLimited investigationFinal reportCessna 182RG · Manhattan, KSthe instructor pilot allowing an excessive descent rate to develop and not correcting the excessive descent rate.NTSB CHI01FA297Accident · 3 fatalField investigationFinal reportBeech A23 · Stevens Point, WIthe pilot not obtaining/maintaining aircraft control.NTSB ANC01LA129Accident · Minor injuriesLimited investigationFinal reportde Havilland C-7A · Port Alsworth, AKThe captain's failure to maintain the proper glidepath, and improper short field landing procedures. Factors in the accident were a downdraft, and the captain's inadequate evaluation of the weather conditions.NTSB SEA01LA162Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Shelton, WAThe binding/grabbing of the right main gear braking system during the landing roll.NTSB LAX01LA294Accident · 1 fatalLimited investigationFinal reportHarter Kitfox Classic · Sedona, AZThe failure of the pilot to initiate a course reversal in a timely manner after flying into a box canyon and his failure to maintain airspeed during the attempted course reversal, which resulted in a stall spin.NTSB IAD01LA088Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Marietta, PAThe pilot's operation of the airplane with known deficiencies. Also causal was the loss of brake pressure, which resulted in the failure of the right brake, and subsequent loss of control of the airplane.NTSB DCA01WA059Accident · 4 fatalForeign investigationCASA 235 · Malaga, SpainNTSB ATL01LA100Accident · No injuriesLimited investigationFinal reportRockwell S2R · Bentonia, MSThe loss of engine power due to the loss of throttle cable continunity. The throttle cable linkage was worn beyond servicable limits. A factor was uneven terrain at the emergency landing site.NTSB ANC01LA128Accident · No injuriesLimited investigationFinal reportCessna 170B · Fairbanks, AKThe pilot's inadvertent stall/mush during the initial climb after takeoff, and subsequent in-flight collision with a tree.