NTSB investigations, 2005
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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\") = 2005 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") = 2005 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 DEN05LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-180 · Ogden, UTthe flight instructor's failure to maintain adequate airspeed resulting in an inadvertent stall. Contributing factor's include the flight instructor's improper pre-flight planning and decision in accepting the intersection departure, and the flight…NTSB CHI05TA251Accident · No injuriesFinal reportCessna 182R · New Ulm, MNThe loss of engine power for undetermined reasons resulting in a forced landing. A contributing factor was the soft terrain condition.NTSB ATL05LA156Accident · No injuriesLimited investigationFinal reportCessna 172S · Opa Locka, FLA loss of engine power for undetermined reasons.NTSB LAX05CA282Accident · No injuriesData collectionFinal reportBellanca 7ECA · San Jose, CAthe pilot's failure to maintain directional control of the airplane during the landing flare, which resulted in a collision with an runway sign.NTSB SEA05LA184Accident · No injuriesLimited investigationFinal reportAirbus Industrie A330-223 · Portland, ORThe failure of the flightcrew of the other airplane to maintain clearance while taxiing.NTSB LAX05LA281Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob Flugzeugbau G102 Club Astir Iiib · Minden, NVthe student pilot's failure to ensure that the canopy was properly latched prior to departure. The inadequate supervision of the flight by the instructor and flight school was also causal.NTSB DFW05CA224Accident · No injuriesData collectionFinal reportCessna 152 · Tulsa, OKThe pilot's improper recovery from a bounced landing. A contributing factor was the dark night conditions.NTSB CHI05CA246Accident · No injuriesData collectionFinal reportAyres S2R-G10 · Davenport, NDThe pilot failed to gain suffient altitude during takeoff in order to clear the corn crop at the end of the runway. A factor associated with the accident was the corn crop.NTSB CHI05CA245Accident · No injuriesData collectionFinal reportAir Tractor AT-502 · Hector, MNThe pilot's failure to achieve adequate airspeed on takeoff which resulted in the airplane entering a stall/mush when it flew out of ground effect while crossing a large drainage ditch on takeoff.NTSB ANC05LA130Accident · No injuriesLimited investigationFinal reportCessna 441 · Anchorage, AKThe pilot's failure to lower the airplane's landing gear during landing, which resulted in an inadvertent wheels up landing.NTSB ANC05CA132Accident · No injuriesData collectionFinal reportCessna 172 · Tyonek, AKThe pilot's inadequate compensation for wind conditions during takeoff-initial climb, which resulted in a loss of control, and subsequent in-flight collision with a creek. A factor associated with the accident is a sudden windshift.NTSB ANC05CA131Accident · No injuriesData collectionFinal reportMaule M-5-210C · Fairbanks, AKThe pilot's inadequate compensation for wind conditions during the landing roll, which resulted in a loss of control and subsequent collapse of the main landing gear. Factors associated with the accident were a crosswind, and a steep drop-off.NTSB CHI05LA243Accident · 1 fatalLimited investigationFinal reportAllensworth Baby Belle · El Dara, ILThe manufacturer failed to specify a relief radius on the tail rotor spindle drawings, which resulted in the spindle being manufactured with an inadequate relief radius at the point of fatigue failure.NTSB CHI05CA248Accident · No injuriesData collectionFinal reportPiper PA-28-180 · McConnell, ILThe pilot's inadequate preflight/planning which resulted in the attempted takeoff on the soft airstrip. Factors associated with the accident were the soft terrain, the corn crop, and the inadequate airspeed achieved during the takeoff roll.NTSB CHI05CA247Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Ypsilanti, MIThe pilot's failure to maintain adequate airspeed which resulted in his inability to properly flare the airplane and the subsequent hard landing.NTSB ATL05LA154Accident · 2 fatalLimited investigationFinal reportSamson Seawind 3000 · Wrightsville Bh, NCThe pilot's improper preflight decision to attempt night VFR flight into IMC, which resulted in an inflight encounter with weather and the pilot's subsequent loss of control of the airplane due to spatial disorientation.NTSB ATL05CA155Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Destin, FLThe loss of engine power for undetermined reasons.NTSB SEA05FA181Accident · 2 fatalField investigationFinal reportPiper PA-14 · Challis, IDThe pilot's failure to maintain aircraft control and the subsequent inadvertent stall/spin to the ground. A contributing factor was the pilot's diverted attention while spotting/locating Rocky Mountain Bighorn sheep.NTSB SEA05CA183Accident · No injuriesData collectionFinal reportBellanca 7KCAB · Chiloquin, ORThe failure of the left chain link which permits the pilot to control the tailwheel, and the subsequent inability of the pilot to control the airplane during the landing roll.NTSB SEA05CA182Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta · Boise, IDInadequate communications between the certified flight instructor and student pilot, and the student pilot's delay in relinquishing controls resulting in a hard landing during a practice autorotation.NTSB NYC05LA139Accident · No injuriesLimited investigationFinal reportTerrio Pober Jr Ace · Oxford, CTA fractured oil pressure line, which resulted in the fracture of the number 3 cylinder connecting rod bearing, and subsequent loss of engine power.NTSB NYC05FA138Accident · 1 fatalField investigationFinal reportCessna 172C · Winthrop, METhe pilot's inadequate preflight inspection, which resulted in a loss of engine power due to fuel exhaustion, and a subsequent forced landing and impact with terrain.NTSB IAD05FA146Accident · 3 fatalField investigationFinal reportPiper PA-28RT-201 · Dunkirk, NYLoss of control for undetermined reasons.NTSB IAD05CA128Accident · No injuriesData collectionFinal reportPresley RV-4 · Biddeford, METhe pilot's failure to maintain directional control. Contributing to the accident was the wind gusts.NTSB DEN05CA132Accident · No injuriesData collectionFinal reportCessna 180J · Afton, WYloss of engine power for reasons undetermined.NTSB IAD05LA126Accident · 1 fatalLimited investigationFinal reportCessna 172H · Corry, PAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall and collision with terrain.NTSB LAX05LA279Accident · Minor injuriesLimited investigationFinal reportBeech 35-A33 · Alturas, CAThe loss of engine power for undertermined reasons.NTSB LAX05CA280Accident · No injuriesData collectionFinal reportPiper PA-28-236 · San Martin, CAthe pilot's failure to maintain directional control of the airplane during the landing roll. A factor in the accident was the spongy brakes.NTSB DEN05LA130Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Falcon, COthe pilot's failure to maintain control of the helicopter while conducting a hovering maneuver.NTSB CHI05CA244Accident · No injuriesData collectionFinal reportCessna 414 · Drummond Island, MIThe right main gear collapsed due to undetermined reasons. A factor associated with the accident was the fence that the airplane contacted.NTSB SEA05FA180Accident · 1 fatalField investigationFinal reportMaule Bee Dee M-4 · Ritter, ORThe loss of control for an undetermined reason which resulted in a ground collision.NTSB NYC05LA137Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-D · Sandy Lake, PAA total failure of the engine driven fuel pump, and the pilot's failure to recognize a diminishing fuel supply in the fuselage (header) fuel tank, which resulted in a total loss of engine power during cruise flight and subsequent collision with trees during a…NTSB ATL05CA153Accident · No injuriesData collectionFinal reportCessna 172S · Savannah, GAThe instructor's inadequate supervision and failure to maintain directional control, resulting in an on ground collision with terrain.NTSB NYC05CA136Accident · Minor injuriesData collectionFinal reportHanek Pitts S1S · Mercer, PAThe pilot's failure to maintain directional control during takeoff, which resulted in an on ground encounter with crops. A factor in this accident was the crosswind condition, as reported by the pilot.NTSB LAX05TA277Accident · Minor injuriesFinal reportWSK PZL Mielec M-18A · Elko, NVthe pilot's failure to adequately plan for the wind direction and speed during a fire retardant delivery flight, which led to a loss of true airspeed, failure to attain a proper climb rate, and the in-flight collision with mountainous terrain. Contributing…NTSB IAD05RA127Accident · 45 fatalForeign investigationBoeing 737-200 · Pucallpa, PeruNTSB DFW05CA220Accident · No injuriesData collectionFinal reportRobinson R-44 · Odessa, TXThe pilot's failure to maintain main rotor RPM and the improper landing flare which resulted in a hard landing.NTSB ATL05WA152Accident · 4 fatalForeign investigationCessna 172 · Simplon, SwitzerlandNTSB ANC05LA129Accident · Minor injuriesLimited investigationFinal reportde Havilland Beaver DHC-2 MK.1 · Aleknagik, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in a loss of control during the takeoff roll, and an encounter with high vegetation and a river bank. Factors associated with the accident are high vegetation and a riverbank.NTSB SEA05LA179Accident · No injuriesLimited investigationFinal reportAmerican Champion 7KCAB · Richland, WAThe oil pressure gauge line fitting coming loose from the engine, resulting in the loss of oil to the point where internal engine components were starved for oil, leading to extensive internal damage and seizing of the engine. Factors include a set of eight…NTSB MIA05CA153Accident · Minor injuriesData collectionFinal reportCessna 152 · Sanford, FLThe student pilot's loss of aircraft control during the landing flare and touchdown resulting in the wing contacting the runway and the airplane nosing over.NTSB LAX05CA276Accident · No injuriesData collectionFinal reportCessna 172N · Ramona, CAthe pilot's failure to maintain directional control during landing.NTSB IAD05FA125Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · West Chester, PAThe pilot's improper decision to abort the landing after the airplane contacted the runway. A factor in the accident was the pilot's failure to ensure the landing gear was extended during the landing.NTSB ATL05CA151Accident · Minor injuriesData collectionFinal reportPiper PA-18-105 · N. Myrtle Beach, SCThe loss of engine power due to the pilot's failure to use carburetor heat, which resulted in the formation of carburetor ice.NTSB ANC05LA128Accident · No injuriesLimited investigationFinal reportGardner SR3500 · Anchorage, AKThe malfunction of the propeller reversing system during landing, which allowed the propeller to reverse pitch in-flight, resulting in an uncontrolled descent and impact with terrain.NTSB NYC05CA135Accident · No injuriesData collectionFinal reportPiper PA-24-180 · Hancock, NYThe pilot's inadequate compensation for wind conditions, which resulted in the airplane impacting the ground. A factor in the accident was the downdraft wind condition, as reported by the pilot.NTSB LAX05CA274Accident · No injuriesData collectionFinal reportBeech A36 · Healdsburg, CAthe pilot's failure to maintain lateral aircraft control during takeoff.NTSB IAD05CA124Accident · No injuriesData collectionFinal reportCessna 421C · Readington, NJAn encounter with animals during the landing - flare/touchdown.NTSB DFW05CA219Accident · No injuriesData collectionFinal reportCessna 172R · Springtown, TXThe pilot's improper decision to shut down the engine. Contributing factors were the failure of the oil pressure switch and the lack of a suitable landing area.NTSB CHI05LA237Accident · 1 fatalLimited investigationFinal reportKircher RV-8 · Menomonie, WIThe pilot's decision to perform an aerobatic roll during takeoff, the low altitude, and his failure to maintain clearance from the crops and terrain.