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 LAX01FA236Accident · No injuriesField investigationFinal reportBell 47D-1 · Riverside, CAThe engine crankshaft's failure as the result of fatigue cracking initiated by surface damage and localized overheating due to the installation at overhaul of incorrectly sized bearings.NTSB IAD01LA077Accident · Minor injuriesLimited investigationFinal reportGarro Sonerai II · Cortland, OHthe pilot's failure to maintain directional control during an aborted take-off. A factor was the pilot's failure to obtain adequate take-off speed.NTSB DEN01LA121Accident · No injuriesLimited investigationFinal reportGriffith-Boyd Lancair 360 · La Junta, COa wheels-up landing due to an uncommanded gear retraction resulting from a short circuit of the landing gear electrical wiring.NTSB ATL01WA079Accident · No injuriesForeign investigationLockheed L-1011 · Lyon St Exupery, FranceNTSB ATL01LA084Accident · No injuriesLimited investigationFinal reportFleet BI-PLANE · Homestead, FLThe pilot's improper use of flight controls during a landing on a sod airstrip that resulted in a nose over.NTSB ATL01LA074Accident · No injuriesLimited investigationFinal reportCessna 208B · Ft. Lauderdale, FLThe undetermined malfunction of the propeller system.NTSB WAS01WA015Accident · 8 fatalForeign investigationSikorsky S-76B · P'ohang, South KoreaNTSB NYC01LA164Accident · Serious injuriesLimited investigationFinal reportStinson 108-3 · Friendly, MDA baffling failure within the exhaust system. Factors were an inadequate annual inspection and the pilot's operation of the airplane with known deficiencies in equipment.NTSB IAD01LA076Accident · Minor injuriesLimited investigationFinal reportRolladen-Schneider LS3-A · Front Royal, VAthe pilot's inadequate altitude/clearance from a tree along his final approach path.NTSB CHI01LA308Accident · No injuriesLimited investigationFinal reportCessna 182K · Mattoon, ILThe pilot improperly flared the airplane which resulted in a hard landing.NTSB ATL01LA072Accident · No injuriesLimited investigationFinal reportRyan Navion B · Palm Beach, FLLoss of engine power for undetermined reasons.NTSB LAX01LA235Accident · No injuriesLimited investigationFinal reportCessna 175 · Monterey, CAThe pilot's improper recovery from a bounced landing.NTSB LAX01FA234Accident · No injuriesField investigationFinal reportBeech 35A · Linden, CAThe engine lost power for undetermined reasons.NTSB FTW01LA160Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Mount Pleasant, TXthe pilot's inadvertent ground loop during the landing roll. A contributing factor was his lack of total experience in tail wheel-equipped airplanes.NTSB FTW01LA159Accident · No injuriesLimited investigationFinal reportGlover RV-8 · Mineral Wells, TXthe jammed elevator control stick on takeoff roll. A contributory factor was the crosswind.NTSB FTW01LA158Accident · 1 fatalLimited investigationFinal reportPiper PA-32R-300 · Belle Chase, LAthe pilot's failure to maintain clearance with a utility pole while maneuvering. Contributing factors were the pilot's impairment due to alcohol intoxication and the night light conditions.NTSB CHI01LA193Accident · No injuriesLimited investigationFinal reportCessna 182 · Taylorville, ILThe pilot's improper procedure and the unsuitable terrain encountered during the forced landing. Additional factors included the carburetor icing and the corn crop.NTSB ATL01LA073Accident · No injuriesLimited investigationFinal reportChristen Industries Eagle II · Belleview, FLThe pilot of the Christian Ealge II, N321JK, failure to maintain visual look out, prior to takeoff.NTSB ATL01LA071Accident · Serious injuriesLimited investigationFinal reportLake LA-4 · Mulberry, FLThe loss of engine power for undetermined reasons. A factor was rough and uneven terrain.NTSB WAS01RA013Accident · 2 fatalForeign investigationCessna U206G · San Ignacio, BoliviaNTSB NYC01LA165Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Plymouth, MAThe pilot's failure to ensure the magnetos were off prior to rotating the propeller, which resulted in an unintentional engine start and subsequent unmanned taxi.NTSB LAX01TA233Accident · No injuriesFinal reportCessna 150 · Delano, CAA bent mixture control valve stem shaft in the carburetor which made pilot control of the mixture inoperative resulting in excessive fuel consumption, and subsequent loss of engine power..NTSB DEN01LA120Accident · No injuriesLimited investigationFinal reportCessna 172Q · Englewood, COthe pilot's failure to properly recover from a bounced landing. A contributing factor were the adverse wind conditions.NTSB CHI01LA197Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Mecosta, MIthe inadequate preflight planning/preparation by the pilot and fuel starvation. Additional causes were the aircraft control not maintained, and the inadvertent stall by the pilot.NTSB ATL01LA070Accident · No injuriesLimited investigationFinal reportHughes 369A · Wadesboro, NCThe pilot's inadequate pre-flight planning which resulted in fuel exhaustion and the subsequent loss of engine power. A factor was rough and uneven terrain.NTSB NYC01LA163Accident · No injuriesLimited investigationFinal reportCessna 172P · Stevensville, MDThe pilot's improper flare and his improper recovery from a bounced landing.NTSB NYC01LA161Accident · No injuriesLimited investigationFinal reportCessna 152 · Manassas, VAThe student pilot's loss of control of the airplane after bouncing the landing. A factor in the accident was her heightened anxiety over making her first solo landing.NTSB NYC01FA158Accident · 1 fatalField investigationFinal reportMoravan Zlin 526F · Queen Anne, MDThe pilot's failure to maintain airspeed during an aerobatic maneuver, which resulted in an inadvertent inverted spin.NTSB MIA01LA178Accident · Serious injuriesLimited investigationFinal reportCessna 188B · Leesburg, FLThe pilot's failure to maintain a visual lookout while deploying the grappling hook in preparation for a banner pick up resulting in the cable wrapping around the stabilizer, subsequent loss of control during the banner drop (due to the cable moving forward…NTSB LAX01LA232Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Hayward, CAthe student's excessive rate of descent during a practice autorotation, and, the inadequate use of the rotorcraft flight controls by both pilots during the attempted recovery, which resulted in a hard landing. The flight instructor's inadequate supervision…NTSB IAD01LA101Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Columbus, OHThe pilot's loss of control after turning his head into the slipstream outside of the helicopter.NTSB IAD01LA074Accident · No injuriesLimited investigationFinal reportCessna 182S · Montgomery, NYThe pilot's improper flare, and improper recovery from a bounced landing.NTSB CHI01LA199Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Albion, ILthe maintenance performed on the airplane by the unqualified pilot The unsuitable takeoff area selected by the pilot was an additional cause. The ditch was a contributing factor.NTSB CHI01LA195Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Ellinwood, KSThe pilot failed to see and avoid the guy wire during an aerial application flight. A factor associated with the accident was the guy wire.NTSB CHI01LA194Accident · 1 fatalLimited investigationFinal reportHouston Challenger II · Sedalia, MOthe unsuitable terrain encountered during the forced landing. Additional factors were the pilot's lack of experience in the type of airplane, the loss of engine power for undetermined reasons, and the trees.NTSB ANC01LA081Accident · No injuriesLimited investigationFinal reportLockheed L-382G · Lake Minchumina, AKThe flight crew's improper recovery from a bounced landing. Factors associated with the accident were the selection of an unsuitable landing area, and a rough/uneven landing surface.NTSB ANC01LA079Accident · No injuriesLimited investigationFinal reportCessna 180 · Willow, AKA fire of undetermined origin, following a precautionary landing.NTSB SEA01LA124Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Lewistown, MTPilot's failure to maintain directional control of the aircraft while landing.NTSB MIA01WA184Accident · 1 fatalForeign investigationCessna 172 · Sonnblick, AustriaNTSB LAX01LA231Accident · No injuriesLimited investigationFinal reportCessna 172N · Boulder City, NVthe loss of engine power while in cruise flight due to the mechanic's improper magneto timing.NTSB LAX01LA230Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Nixon, NVThe pilot’s failure to attain the proper touchdown point and his misjudged distance/speed during landing rollout. Factors were the tailwind condition and the downhill landing area.NTSB LAX01LA229Accident · Serious injuriesLimited investigationFinal reportSmith FW-190 · Reedley, CAThe pilot's failure to maintain airspeed during takeoff, which resulted in an inadvertent stall.NTSB IAD01WA075Accident · Minor injuriesForeign investigationAmerican Blimp A-1-50 · Toronto, CanadaNTSB DEN01LA119Accident · No injuriesLimited investigationFinal reportCessna 177RG · Broomfield, COfailure of the nose landing gear hydraulic UP hose, which resulted in a wheels-up landing..NTSB ANC01LA080Accident · No injuriesLimited investigationFinal reportBeech H35 · Chitina, AKThe pilot's inadequate compensation for wind conditions. Factors associated with the accident are variable winds, and a downdraft.NTSB NYC01LA160Accident · No injuriesLimited investigationFinal reportChek Avid Mark IV · Salisbury, MDThe pilot's failure to maintain airplane control. Factors were the quartering tailwind, and the improper rebuild of the left main landing gear with a reduced size brace.NTSB NYC01LA157Accident · No injuriesLimited investigationFinal reportCessna 152 · Warrenton, VAThe airplane's encounter with a deer during a touch and go.NTSB DEN01LA118Accident · No injuriesLimited investigationFinal reportBeech BE76 · Hudson, COmain landing gear collapse on touchdown for reasons undetermined.NTSB CHI01LA192Accident · Minor injuriesLimited investigationFinal reportMelenyk Genesis · Howell, MIthe in-flight planning/decision by the pilot. Contributing factors were the undetermined loss of engine power, the quartering tailwind and the unsuitable terrain encountered by the pilot.NTSB CHI01LA191Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Grygla, MNThe pilot not maintaining altitude/clearance from terrain on takeoff. A factor was the high density altitude.