NTSB investigations, 2005
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\") = 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 MIA06FA008Accident · 1 fatalField investigationFinal reportCessna P337H · Port St. Lucie, FLThe pilot's continued flight into an area of known convective weather, resulting in a loss of aircraft control. Contributing factors were the failure of the FAA center controller to provide information on depicted severe weather to the pilot and the…NTSB MIA06CA011Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Vero Beach, FLThe failure of the pilot to maintain directional control of the airplane during the landing roll resulting in the on-ground collision with runway signs.NTSB LAX06LA015Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Avalon, CAthe pilot's failure to maintain an adequate visual lookout and obstacle clearance altitude, which resulted in a collision with power lines. Factors in the accident were the position of the sun relative to the helicopter's flight path, which lessoned the…NTSB LAX06CA013Accident · Minor injuriesData collectionFinal reportPiper PA-23-160 · Upland, CAthe pilot's failure to maintain directional control during landing.NTSB DFW06LA010Accident · Minor injuriesLimited investigationFinal reportCessna 208 · Round Rock, TXThe loss of engine power due to the failure of the engine-driven fuel pump. A contributing factor was the inadequate inspection of the engine driven fuel pump.NTSB DFW06CA017Accident · No injuriesData collectionFinal reportHawker Siddeley 125-700 · Houston, TXThe pilot-in-command's failure to attain proper runway alignment.NTSB CHI06CA014Accident · No injuriesData collectionFinal reportCessna 210C · Kankakee, ILA hydraulic line leak causing a loss of hydraulic fluid and subsequent failure of the hydraulic system. An additional cause was the inoperative landing gear extension system, both normal and emergency, due to a complete loss of the hydraulic system.NTSB MIA06CA005Accident · No injuriesData collectionFinal reportCessna 172R · Bunnell, FLThe pilot's misjudged distance/speed, and his delayed braking during landing, which resulted in the airplane overrunning the runway and impacting a ditch.NTSB SEA06WA042Accident · 1 fatalForeign investigationCessna 185 · Limestone Lake, CanadaNTSB NYC06LA011Accident · No injuriesLimited investigationFinal reportBeech 1900D · Ogdensburg, NYA collision with a coyote during the takeoff roll, which resulted in a nosegear collapse and subsequent impact with the runway. A factor was the nighttime condition.NTSB LAX06LA017Accident · No injuriesLimited investigationFinal reportNorth American T-39A · Mojave, CAThe pilot's failure to maintain aircraft control during the landing roll. A wet runway surface was a factor.NTSB LAX06FA014Accident · 3 fatalField investigationFinal reportLancair LC-41-550FG · Warner Springs, CAThe flight crew's failure to maintain adequate terrain clearance and their decision to continue flight into known adverse weather conditions. Contributing to the accident was overcast conditions, and terrain obscuration. A finding of the investigation is that…NTSB DFW06CA008Accident · Minor injuriesData collectionFinal reportCessna 172P · Hitchcock, TXA loss of engine power due to a cracked cylinder.NTSB CHI06IA011Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · West Grove, PAThe separation of the left engine exhaust nozzle during cruise climb due to inadequately designed attachment hardware.NTSB WAS06WA002Accident · 5 fatalForeign investigationCessna U206P · Mahone, TanzaniaNTSB MIA06FA007Accident · 1 fatalField investigationFinal reportCessna 172P · La Belle, FLThe student pilot's failure to maintain airspeed during the initial takeoff climb, resulting in an inadvertent stall/spin and uncontrolled descent to ground impact. A contributing factor was the failure of the wing flap control, which resulted in the flaps…NTSB MIA06CA010Accident · No injuriesData collectionFinal reportCessna 182J · Punta Gorda, FLThe pilot's inadequate remedial action following an encounter with wind gusts during the landing flare resulting in a hard landing and damage to the nose landing gear.NTSB DFW06LA007Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Big Flat, ARThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for a forced landing.NTSB CHI06CA013Accident · Minor injuriesData collectionFinal reportCessna 152 · Peoria, ILThe student pilot's failure to maintain adequate airspeed during a go-around which resulted in the airplane stalling.NTSB ATL06LA008Accident · 1 fatalLimited investigationFinal reportElan/Glaser Dirks DG-300 · Brownsboro, ALThe pilot's misjudgment of distance/altitude on final approach which resulted in an undershoot of the runway, and an in-flight collision with a embankment. A factor was the dirt bank/rising terrain.NTSB SEA06LA006Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Burlington, WAThe pilot's failure to maintain clearance from a utility pole during a precautionary landing. The utility pole was a factor.NTSB SEA06LA005Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Newberg, ORThe flight instructor's failure to maintain airspeed while on approach for landing resulting in an inadvertent stall. Wind gusts, trees and an undetermined loss of engine power were factors.NTSB SEA06FA007Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Everett, WAThe pilot's inadequate airspeed during his aborted landing takeoff/climb which lead to a series of stall/mushes and subsequent impact with trees. Contributing factors were the pilot's loss of aircraft control during his initial landing approach and his…NTSB MIA06LA006Accident · 1 fatalLimited investigationFinal reportSteven W. Jones KR2 · Venice, FLThe in-flight collision with the water for undetermined reasons.NTSB LAX06CA019Accident · No injuriesData collectionFinal reportHarmel RV6A · Oceanside, CAthe pilot-induced oscillations encountered on landing following the pilot's misjudged landing flare and premature release of elevator backpressure during touchdown.NTSB LAX06CA010Accident · No injuriesData collectionFinal reportCessna 182B · Mokelumne Hill, CAthe pilot's improper flare resulting in a hard landing. A related factor was gusty wind conditions.NTSB DFW06WA012Incident · No injuriesForeign investigationCessna 208B · Belize City, BelizeNTSB CHI06LA012Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Williams, MNThe pilot's failure to maintain airspeed which resulted in the airplane stalling. Factors associated with the accident were the low level at which the airplane was maneuvering and the pilot's failure to perform weight and balance calculations prior to the…NTSB CHI06CA035Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Imperial, NEThe pilot not maintaining airplane control during the takeoff.NTSB ATL06LA007Accident · 1 fatalLimited investigationFinal reportNorth American AT-6D · Mocksville, NCThe pilot's improper fuel management resulting in a total loss of engine power due to fuel starvation and an in-flight collision with trees and the ground.NTSB SEA06CA013Accident · Serious injuriesData collectionFinal reportNorth Wing Apache ST Trike · Medical Lake, WAThe loss of engine power while maneuvering for undetermined reasons.NTSB LAX06LA006Accident · 2 fatalLimited investigationFinal reportRobinson Helicopter R-22 Beta II · Eagar, AZThe pilots' inadequate in-flight planning, which led the helicopter toward rising terrain in excess of the performance capability of the helicopter. Contributing factors were the high density altitude, and the rapidly rising terrain.NTSB LAX06IA011Incident · No injuriesIncident investigationFinal reportHughes 369D · Kahului, HIThe fatigue cracking and failure of the tail rotor control rod during cruise flight, which resulted in a hard landing during the precautionary landing.NTSB CHI06FA010Accident · 4 fatalField investigationFinal reportPlavcan Lancair 235 · Rootstown, OHThe failure of both pilots to maintain an adequate visual lookout during cruise flight, which resulted in their failure to see and avoid each other and a midair collision.NTSB CHI06CA009Accident · No injuriesData collectionFinal reportCessna U206G · Hanover, MIThe pilot misjudged the landing flare which resulted in the bounced landing and subsequent overload failure of the nose landing gear wheel. A factor associated with the accident was the grass airstrip.NTSB ATL06CA006Accident · Serious injuriesData collectionFinal report1200 G103 · Benton, TNThe pilot's misjudgment of distance and failure to maintain a visual look out during a forced landing resulting in an in flight collision with a guy wire and the ground.NTSB ATL06CA005Accident · No injuriesData collectionFinal reportCessna 150M · Morgantown, NCThe student pilot's improper recovery from a bounced landing,resulting in a loss of directional control and nose over.NTSB ANC06LA005Accident · No injuriesLimited investigationFinal reportCrisenbery Northman 2+2 · Nenana, AKA loss of engine power during cruise flight due to a cracked oil filter housing and subsequent loss of engine oil, which resulted in a forced landing in trees.NTSB NYC06LA010Accident · 1 fatalLimited investigationFinal reportCessna 150F · Pineville, KYThe pilot's continued VFR flight into IMC conditions, which resulted in controlled flight into terrain. Factors in the accident were the low cloud ceiling and fog.NTSB LAX06LA009Accident · No injuriesLimited investigationFinal reportBoeing 737-7H4 · Phoenix, AZThe failure of the other flight crew to maintain an adequate clearance from obstructions while taxiing.NTSB CHI06CA008Accident · Minor injuriesData collectionFinal reportCessna 310R · Ottumwa, IAThe pilot misjudged his altitude and airspeed while landing which resulted in the airplane stalling 20 feet above the runway. A factor associated with the accident was the pilot's execution of the approach when reported weather conditions were below the…NTSB NYC06CA009Accident · No injuriesData collectionFinal reportSikorsky S-76B · New York City, NYThe pilot flying's failure to maintain adequate aft hover clearance from a fence, and the pilot in command's delayed remedial action. A factor was the dark night lighting conditions.NTSB DFW06CA004Accident · No injuriesData collectionFinal reportCessna 172 · Spring, TXThe pilot's failure to maintain directional control while landing.NTSB DEN06LA007Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · New Century, KSloss of engine power due to the pilot's improper use of carbuetor heat and his improper inflight planning/decision. Contributing factors were the inadequate supervision of the student by the flight instructor, conditions conducive to carburetor ice, dark…NTSB ATL06CA004Accident · No injuriesData collectionFinal reportBeech F33A · Millington, TNThe pilot's improper fuel management resulting in a total loss of engine power due to fuel starvation. A factor in the accident was the pilot's failure to maintain airspeed and misjudged distance to the forced landing area resulting in a stall and collision…NTSB NYC06CA008Accident · No injuriesData collectionFinal reportEnstrom F-28C · Smoketown, PAThe student pilot's failure to maintain aircraft control while performing pedal turns at a hover, resulting in a collision with terrain.NTSB LAX06CA008Accident · No injuriesData collectionFinal reportBellanca 17-30A · Riverside, CAThe failure of the steering control rod during an unknown phase of the accident flight that resulted in the unavailability of steering control upon landing.NTSB LAX06CA007Accident · No injuriesData collectionFinal reportAppel RDA 04 · Clovis, NMa loss of engine power due to water contamination of the fuel system. The inadequate placement of the fuel system drain by the builder was a factor.NTSB LAX06FA005Accident · 2 fatalField investigationFinal reportAmerican Champion 8KCAB · Oroville, CAThe certified flight instructor and the private pilot's failure to maintain adequate airspeed while attempting a return to runway maneuver, which resulted in an inadvertent stall.NTSB DEN06IA008Incident · No injuriesIncident investigationFinal reportAirbus Industries A319-111 · Denver, COthe de-ice vehicle operator's failure to follow post de-icing procedures, resulting in a collision. Contributing factors were the fog, snow, and the de-icing vehicle.