NTSB investigations, 2005
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 ATL05CA102Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Luka, MSLoss of engine power due to the total failure of the exhaust valve on the number 2 cylinder, and the pilot's misjudgment of speed/distance/altitude which resulted in a overshoot of the runway and subsequent in-flight collision with trees. A factor was the…NTSB SEA05LA120Accident · No injuriesLimited investigationFinal reportMBB BO-105 · Billings, MTThe pilot's improper in-flight decision to continue a simulated engine-out autorotation after sensing an excessive descent rate at 100 feet above the ground. Factors include the excessive descent rate, variable winds, and a high density altitude.NTSB NYC05CA101Accident · No injuriesData collectionFinal reportValentin Taifun 17E · Waterbury, CTThe pilots inadvertent encounter with a downdraft, which resulted in the airplane impacting trees.NTSB LAX05CA211Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Phoenix, AZthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during the landing rollout.NTSB IAD05MA078Accident · Serious injuriesMajor investigationFinal reportSikorsky S-76C · New York, NYAn inadvertent encounter with a left quartering tailwind. Factors in the accident were settling with power, the high gross weight of the helicopter, and the crew's failure to accurately assess the winds in the area.NTSB IAD05LA079Accident · No injuriesLimited investigationFinal reportCessna 414 · Butler, PAThe pilot's decision to conduct the flight with a known equipment deficiency. A factor was the tailwind condition.NTSB DFW05LA162Accident · 1 fatalLimited investigationFinal reportWsk-Pzl Mielec M18B · Eudora, ARThe pilot's failure to maintain clearance from the tree.NTSB DFW05CA163Accident · No injuriesData collectionFinal reportCarterCopter CarterCopter · Olney, TXThe pilot's inability to maintain control of the gyrocraft during a forced landing as a result of a loss of cyclic and collective control. Contributing factors were the sheared propeller drive pulley bolts, broken wire on the co-pilots cyclic boost control…NTSB DEN05LA091Accident · No injuriesLimited investigationFinal reportCessna 340A · Santa Fe, NMtotal failure of the main landing gear due to improper installation of the push-pull tubes by maintenance personnel, and their failure to follow proper procedures/directives.NTSB CHI05LA148Accident · 1 fatalLimited investigationFinal reportReay Titan Tornado II · Winsted, MNThe pilot performed an unauthorized aerobatic loop and failed to maintain control of the airplane.NTSB CHI05CA151Accident · No injuriesData collectionFinal reportKirby Christen Eagle · Wheeling, ILThe pilot's inadequate compensation for the wind conditions, and his failure to maintain obstacle clearance, which resulted in the airplane drifting during the landing flare and impacting the taxiway light.NTSB ATL05LA101Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Fort Myers, FLA loss of engine power due to the connecting rod cap separation for undetermined reasons. Related factors were trees and the swampy terrain condition.NTSB SEA05LA118Accident · Minor injuriesLimited investigationFinal reportRash Vans RV-6A · Palouse, WALoss of engine power for undetermined reasons. Rising terrain was a factor.NTSB LAX05LA214Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Happy Jack, AZThe fracture/separation of an engine intake valve during cruise flight, which resulted in a partial loss of engine power and a forced landing.NTSB DFW05CA164Accident · No injuriesData collectionFinal reportCessna 152 · Burneyville, OKThe students pilot's improper flare and his failure to maintain directional control of the airplane. A contributing factor was the bounced landing.NTSB CHI05CA144Accident · Serious injuriesData collectionFinal reportCessna 150M · Marcelles, MIThe total loss of engine power due to fuel exhaustion as a result of the CFI's inadequate supervision and inadequate planning/decision. The student pilot's inadequate preflight planning was a contributing factor.NTSB ATL05FA098Accident · 2 fatalField investigationFinal reportFairchild M-62A-3 · Williamson, GAThe pilot's failure to follow the before takeoff checklist and attempted a takeoff with flaps extended, which resulted in an in-flight collision with trees.NTSB ATL05CA129Accident · No injuriesData collectionFinal reportLuscombe 8E · Orangeburg, SCThe pilot's failure to maintain directional control during landing roll.NTSB ATL05CA100Accident · No injuriesData collectionFinal reportGoodyear GZ-20A · Coral Springs, FLThe pilot's inadequate in-flight planning/decision which resulted in an in-flight encounter with weather (thunderstorm outflow), and downdrafts, loss of control and subsequent collision with trees and transmission wires.NTSB ATL05CA099Accident · Minor injuriesData collectionFinal reportCessna 150M · Panama City, FLThe pilot's misjudgment of distance/altitude while on final approach with a tailwind, which resulted in an undershoot of the runway.NTSB ATL05CA097Accident · No injuriesData collectionFinal reportCessna 152 · Fort Payne, ALThe intentional unauthorized use of a stolen aircraft by an unqualified person which resulted in a hard landing and substantial damage to the airplane.NTSB ANC05LA088Accident · No injuriesLimited investigationFinal reportAerospatiale ATR-42-300 · Anchorage, AKA lightning strike during a normal descent for landing, which resulted in structural damage to the airplane's left aileron.NTSB LAX05CA205Accident · Minor injuriesData collectionFinal reportCessna 177B · Fallon, NVthe pilot's inadequate preflight planning, which resulted in fuel exhaustion.NTSB IAD05LA077Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Southampton, NJA lack of lubrication for undetermined reasons which resulted in the failure of the Nos. 4 and 5 connecting rods, and a subsequent total loss of engine power. A factor in the accident was the furrowed cornfield.NTSB DFW05LA159Accident · 1 fatalLimited investigationFinal reportHughes 269A · Rusk, TXA loss of engine power for undermined reasons, and the subsequent collision with power lines and the ground. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW05CA161Accident · No injuriesData collectionFinal reportCessna A188B · Osceola, ARThe pilot's failure to maintain directional control during takeoff. A contributing factor was the prevailing crosswind.NTSB DEN05FA080Accident · Serious injuriesField investigationFinal reportSchweizer 269C · Pueblo, COthe flight instructor's failure to maintain control of the helicopter during the attempted autorotation after the loss of engine power for reasons undetermined. Contributing factors include the flight instructor's improper preflight planning, the high density…NTSB CHI05LA143Accident · No injuriesLimited investigationFinal reportThomas Zenith CH701 · Redford, MIThe total loss of engine thrust was the result of the propeller blades overstress separation from the propeller hub for an undetermined reason. An additional cause was the unsuitable terrain encountered during the forced landing.NTSB CHI05CA142Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Raymore, MOThe loss of total engine power due to fuel exhaustion as a result of the pilot's inadequate preflight. A factor was the unsuitable terrain encountered during the forced landing.NTSB CHI05CA141Accident · No injuriesData collectionFinal reportQuicksilver Sport 2S · Maize, KSThe pilot's inadequate preflight planning that failed to ensure adequate takeoff performance, and his delay in aborting the takeoff.NTSB ANC05LA087Accident · No injuriesLimited investigationFinal reportCessna U206F · Homer, AKThe fracture of the airplane's nose gear scissor during landing, which resulted in a loss of control during the landing roll, and a nose down. A factor associated with the accident was the loss of nosewheel steering control.NTSB NYC05FA099Accident · Serious injuriesField investigationFinal reportBell 206L · New York, NYThe pilot's inadequate preflight planning, which resulted in an attempted takeoff with an overweight helicopter, and subsequent impact with a pier and water. Factors were a high ambient temperature and unfavorable winds.NTSB LAX05LA204Accident · 1 fatalLimited investigationFinal reportBellanca 7GCBC · Woodfords, CAthe pilot's failure to maintain an adequate airspeed while turning in strong wind conditions, which resulted in a stall/spin. A factor in the accident was the high density altitude.NTSB SEA05CA116Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Yellow Pine, IDThe pilot's delay in executing a go-around which resulted in his failure to obtain altitude/clearance with trees.NTSB MIA05FA123Accident · Serious injuriesField investigationFinal reportDouglas R4D-8 · Fort Lauderdale, FLThe inadequate maintenance inspection by company maintenance personnel/pilot and other maintenance personnel of the left engine resulting in a total failure of the master rod bearing, and nose case partial separation, which prevented the left propeller from…NTSB LAX05LA203Accident · Serious injuriesLimited investigationFinal reportBeech C90 · Marble Canyon, AZthe pilot's failure to maintain an adequate airspeed while maneuvering during a go-around, which resulted in a stall.NTSB LAX05FA202Accident · No injuriesField investigationFinal reportBombardier Aerospace CL-600-2B19 · Los Angeles, CAfailure of the nose landing gear to extend to the down and locked position for undetermined reasons.NTSB CHI05LA138Accident · Serious injuriesLimited investigationFinal reportMooney M20K · Jefferson City, MOThe pilot's delay in diverting to an alternate destination due to low fuel indications which led to the fuel exhaustion, loss of engine power and the subsequent forced landing. Factors were the pilot's improper preflight inspection which resulted in an…NTSB CHI05CA146Accident · No injuriesData collectionFinal reportCessna 172N · Madison, WIThe pilot's improper pre-flight which resulted in the control lock not being removed and his subsequent inability to control the airplane. The unmarked control lock and the FBO's failure to replace the unmarked control lock were factors in the accident.NTSB ANC05LA085Accident · Serious injuriesLimited investigationFinal reportCessna U206F · Skwentna, AKThe pilot's improper loading of externally carried lumber that caught fire due to exposure to hot exhaust gases during cruise flight, which resulted in an emergency descent/landing and subsequent collision with a gravel bar. A factor contributing to the…NTSB WAS05WA012Accident · No injuriesForeign investigationBoeing 727-200 · Lagos, NigeriaNTSB SEA05CA117Accident · Minor injuriesData collectionFinal reportPiper PA-25-260 · Geraldine, MTThe pilot's failure to maintain clearance with rising terrain. Rising terrain was a factor.NTSB NYC05LA098Accident · 1 fatalLimited investigationFinal reportNorcutt Hornet · Shelby, OHThe pilot's failure to obtain\maintain the proper climb airspeed during departure, which resulted in an inadvertent stall. A factor in the accident was the pilot's lack of flight experience in the accident airplane make and model.NTSB NYC05LA096Accident · 1 fatalLimited investigationFinal reportHall Maxair Drifter · Gloucester, VAThe in-flight separation of the empennage, which resulted in a loss of control and subsequent impact with the ground.NTSB MIA05LA122Accident · Serious injuriesLimited investigationFinal reportHighsmith Fergy FII B · Chipley, FLThe seizing of the rear engine cylinder during takeoff-initial climb, which resulted in a collision with power lines and structural damage to the airplane during the forced landing.NTSB LAX05LA198Accident · No injuriesLimited investigationFinal reportCessna 210 · Watsonville, CAthe pilot's failure to extend the landing gear prior to landing.NTSB LAX05CA207Accident · No injuriesData collectionFinal reportCessna 172R · Santa Maria, CAthe student pilot's improper flare and recovery from a bounced landing.NTSB LAX05CA200Accident · Minor injuriesData collectionFinal reportAviat Pitts S-1T · Fillmore, CAthe pilot's failure to affect timely recovery from an intentional inverted flat spin.NTSB IAD05LA076Accident · Serious injuriesLimited investigationFinal reportAeronca C-3 · Toughkenamon, PAThe failure of the crankshaft, which resulted in a forced landing and subsequent collision with wires. A factor was the wires.NTSB DEN05LA089Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Cascade, COThe pilot's failure to maintain aircraft control during the attempted landing on mountainous terrain. A contributing factor was strong wind gusts during the attempted landing.