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 ATL01LA056Accident · No injuriesLimited investigationFinal reportCessna 150 · Griffin, GAThe pilot's inadequate preflight fuel planning for the flight that resulted in the fuel exhaustion and the subsequent loss of engine power.NTSB WAS01RA008Accident · 6 fatalForeign investigationBell 407 · Puerto Princesa, PhilippinesNTSB NYC01FA127Accident · Serious injuriesField investigationFinal reportBeech C90 · Islip, NYThe pilot’s failure to activate the fuel transfer pumps in accordance with the check list, which resulted in fuel exhaustion.NTSB LAX01LA185Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Concord, CAThe pilot's inadequate compensation for wind conditions, resulting in a loss of directional control and the inadvertent ground loop.NTSB LAX01LA184Accident · Minor injuriesLimited investigationFinal reportLuscombe 11A · Apple Valley, CAThe pilot's fuel mismanagement, which led to fuel exhaustion, a loss of engine power, and subsequent landing on unsuitable terrain.NTSB LAX01LA181Accident · No injuriesLimited investigationFinal reportCessna 337C · Paauilo, HIA dual loss of engine power for undetermined reasons.NTSB LAX01LA180Accident · No injuriesLimited investigationFinal reportPiper PA18-150 · Tucson, AZThe pilot's inadequate preflight inspection, which included verifying the position of the fuel selector handle, which subsequently led to fuel starvation and a forced landing.NTSB LAX01FA178Accident · 2 fatalField investigationFinal reportBeech D45 · Julian, CAThe pilot's selection of an insufficient altitude over rising mountainous terrain and his failure to maintain adequate terrain clearance.NTSB FTW01LA124Accident · No injuriesLimited investigationFinal reportRobinson R22 · Raymondville, TXthe failure of the main rotor drive belts while maneuvering which resulted in a loss of main rotor drive. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW01LA121Accident · Minor injuriesLimited investigationFinal reportEurocopter AS-350-B2 · Houston, TXthe failure of the pilot to maintain control of the helicopter following an inadvertent deactivation of the hydraulic system, during final approach. A contributory factor was the unguarded hydraulic cut-off switch.NTSB ANC01IA058Incident · No injuriesIncident investigationFinal reportCessna 207 · Quinhagak, AKAn in-flight fracture of the engine crankshaft during descent, precipitated by restricted oil flow through an internal engine oil passage/port.NTSB LAX01LA179Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Paulden, AZCatastropic engine failure due to oil depletetion caused by an oil filter gasket failure.NTSB FTW01LA120Accident · No injuriesLimited investigationFinal reportKirchner Pietenpol Aircamper · Tulsa, OKthe pilot's inadequate flare during the forced landing, which resulted in a hard landing. A contributing factor was the engine overheating due a stuck oil cooler thermostat valve, which resulted in a loss of power.NTSB CHI01LA125Accident · No injuriesLimited investigationFinal reportPiper J5A · Brussels, ILthe partial loss of engine power for undetermined reasons and the high vegitation encountered during the precautionary landing.NTSB CHI01FA139Accident · Serious injuriesField investigationFinal reportBeech 95-C55 · St Cloud, MNthe pilot not maintaining aircraft control during the loss of right engine power during initial climb. Factors were the loss of right engine power for an undetermined reason, the pilot not complying with flight manual emergency procedures, and the trees.NTSB CHI01LA142Accident · Minor injuriesLimited investigationFinal reportBaldwin RV-6 · Muscatine, IAThe engine failure for undetermined reasons. Factors were the low altitude, the trees, the presence of the irrigation system, the ditch and the soft ground.NTSB CHI01LA141Accident · No injuriesLimited investigationFinal reportParker Rotorway 162F · Minneapolis, MNThe tail rotor drive belt coming off in cruise flight and it not being possible for the student pilot to maintain aircraft control during the emergency landing attempt. Factors relating to the accident were the loose bearing in the secondary drive unit to the…NTSB CHI01LA138Accident · 1 fatalLimited investigationFinal reportBrault Glasair SH2F · Green Bay, WIThe pilot allowed the airspeed to get too low and inadvertently stalled the airplane.NTSB CHI01LA137Accident · 1 fatalLimited investigationFinal reportBellanca 14-13-3 · Scott City, KSThe low level roll maneuver the pilot performed on final to runway 17 and his not maintaining clearance from terrain during the maneuver.NTSB CHI01LA134Accident · No injuriesLimited investigationFinal reportAir Tractor G-164A · Casselton, NDThe pilot's failure to maintain directional control of the airplane while recovering from a bounced landing. A factor was the collapse of the right main landing gear.NTSB WAS01WA007Accident · 2 fatalForeign investigationCessna 182 · Zumatlan, MexicoNTSB SEA01IA093Incident · No injuriesIncident investigationFinal reportBeech C-99 · Salem, ORA short to electrical wiring while in cruise flight.NTSB FTW01LA119Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Rosharon, TXthe pilot's failure to maintain aircraft control while maneuvering. Factors were the weather conditions and the muddy terrain.NTSB DEN01LA099Accident · Serious injuriesLimited investigationFinal reportAerostar RX-8 · Sterling, COfailure by the pilot to control descent rate during approach to land. A factor was a temperature inversion.NTSB DEN01FA098Accident · 1 fatalField investigationFinal reportBeech King Air B90 · San Jon, NMthe pilot's failure to maintain aircraft control due to his incapacitation for an undetermined reason. A contributing factor was the subsequent inadvertent stall/spin to the ground.NTSB ATL01LA053Accident · Minor injuriesLimited investigationFinal reportCessna P337H · Fort Lauderdale, FLThe pilot's failure to pre-flight adequate fuel for the flight.NTSB ANC01LA057Accident · No injuriesLimited investigationFinal reportCessna 206 · Stebbins, AKA jammed control yoke during landing, an entangled wiring harness, and inadequate maintenance by company personnel. A factor associated with the accident was the pilot's inability to flare the airplane during landing, due to the mechanical malfunction.NTSB FTW01FA117Accident · 2 fatalField investigationFinal reportConvair BT-13A · Odessa, TXthe pilot's failure to maintain the minimum required airspeed for flight, which resulted in a loss of control while performing a go-around. A contributing factor to the accident was the gusty tailwind condition.NTSB ATL01LA055Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Dunlap, TNThe pilot's failure to obtain liftoff airspeed for undetermined reasons. A factor was tree stumps on the departure end of the takeoff area.NTSB ATL01LA054Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Zephyrhills, FLThe pilots failure to adequately preflight plan fuel for the flight that resulted in fuel exhaustion and the subsequent loss of engine power.NTSB NYC01FA123Accident · 2 fatalField investigationFinal reportCessna 150A · Jackson Twp., PAThe pilot's inadequate visual lookout while manuevering at low level. A factor was the pilot's improper decision to conduct low-level flight.NTSB MIA01FA140Accident · 1 fatalField investigationFinal reportCessna 404 · Pena Pobre, PRfailure of the pilot-in-command to maintain altitude/clearance, resulting in an in-flight collision with rising terrain.NTSB LAX01LA177Accident · No injuriesLimited investigationFinal reportBeech E33A · So Lake Tahoe, CAThe pilot's improper aircraft handling and decision to prematurely raise the landing gear during takeoff. Contributing factors were his lack of experience taking off under the high density altitude condition and his improper maintenance.NTSB LAX01LA176Accident · No injuriesLimited investigationFinal reportLeonard Walters Avid Magnum · Lake Shasta, CAA loss of control on final approach due to encountering a strong wind gust and downdraft.NTSB LAX01LA172Accident · No injuriesLimited investigationFinal reportBell 206B · San Diego, CAthe failure of the ground personnel to maintain clearance between two aircraft on the ramp, while one airplane was taxiing and the other was standing with the engine running and rotor blades turning.NTSB FTW01LA163Accident · No injuriesLimited investigationFinal reportBeech D35 · Houston, TXthe pilot's failure to maintain aircraft control during the takeoff roll.NTSB FTW01FA116Accident · 4 fatalField investigationFinal reportCessna 210K · Leakey, TXThe pilot's failure to maintain obstacle clearance during a go-around, which resulted in the aircraft impacting a tree.NTSB SEA01LA094Accident · No injuriesLimited investigationFinal reportCessna 172 · McMinnville, ORThe student pilot's failure to adequately compensate for wind conditions while doing a touch-and-go landing.NTSB SEA01LA092Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Grants Pass, ORThe pilot's failure or inability to maintain proper runway alignment during landing. Factors included gusty crosswind conditions and the pilot's lack of experience in crosswind landings.NTSB SEA01LA090Accident · No injuriesLimited investigationFinal reportCessna 182P · Salmon, IDLoss of aircraft control while landing. Factors include soft/muddy terrain.NTSB NYC01LA124Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Elizabethtown, KYThe pilot's failure to maintain directional control during the takeoff roll.NTSB NYC01LA121Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 1-26E · New Milford, CTthe student pilot's improper decision to fly northeast of the airport with winds from the southwest, and his subsequent diverted attention to the glider's proximity to the airport while he searched for thermals, which resulted in an off airport landing.NTSB NYC01LA120Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300 · Ithaca, NYThe pilot's failure to follow the published instrument approach procedure.NTSB NYC01FA122Accident · 1 fatalField investigationFinal reportCessna U206E · New Market, VAA loss of engine power due to a failure of the number 5 piston for undetermined reasons. A factor in this accident was the inadequate emergency handling provided by the air route traffic controller.NTSB MIA01WA141Accident · 2 fatalForeign investigationPiper PA-24-250 · Maldon Essex, United KingdomNTSB LAX01LA171Accident · No injuriesLimited investigationFinal reportAeronca 7DC · Hollister, CAThe pilot's inadequate aircraft handling procedure and failure to maintain directional control while landing in a known crosswind.NTSB IAD01WA057Accident · 2 fatalForeign investigationCessna 182S · Leicester, United KingdomNTSB IAD01LA056Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Ashland, MEloss of partial engine power due to carburetor icing.NTSB FTW01LA118Accident · No injuriesLimited investigationFinal reportCessna 310 · Decatur, TXthe flight instructor's failure to maintain directional control during the landing roll. A contributing factor was the left main wheel brake which was locked for an undetermined reason.NTSB DEN01LA097Accident · Minor injuriesLimited investigationFinal report1977 Colfer-Chan Steen Skybolt · Gallup, NMthe pilot's failure to maintain directional control during landing roll. Contributing factors were gusting crosswinds and the pilots's lack of experience in aircraft make and model.