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 NYC05LA063Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Hamburg, NYThe pilot's failure to maintain directional control while landing.NTSB LAX05LA278Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Los Banos, CAthe instructor pilot's failure to apply carburetor heat during a simulated engine failure, which resulted in a total loss of engine power due to carburetor icing.NTSB LAX05LA124Accident · No injuriesLimited investigationFinal reportNorth American AT-6C · Chino, CAthe pilot of the other airplane's failure to maintain an adequate clearance from obstacles while taxiing.NTSB LAX05CA123Accident · No injuriesData collectionFinal reportPeter A. Geiser Lee/Geiser Nieuprt17 · Chandler, AZThe pilot's inadequate compensation for the gusting crosswind condition and failure to maintain directional control during landing rollout.NTSB IAD05WA048Accident · 4 fatalForeign investigationBell 206B · Sirnach, SwitzerlandNTSB IAD05FA047Accident · 6 fatalField investigationFinal reportPilatus PC-12/45 · Bellefonte, PAThe pilot's failure to maintain sufficient airspeed to avoid a stall during an instrument final approach to land, which resulted in an inadvertent stall/spin. Factors associated with the accident are the inadvertent stall/spin, the pilot's failure to follow…NTSB CHI05FA081Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · West Lafayette, INThe pilot's inadvertent flight into instrument conditions and his not maintaining control of the complex airplane during initial climb. Factors in the accident were the low ceiling, the early dawn condition, and the pilots intentional unauthorized use of the…NTSB CHI05CA084Accident · No injuriesData collectionFinal reportCessna 172 · Baudette, MNThe pilot's inadequate compensation for the crosswind which resulted in the failure to maintain directional control of the airplane. Factors associated with the accident were the crosswind, the snow covered surface on which the landing was being made, and the…NTSB MIA05CA082Accident · No injuriesData collectionFinal reportPiper PA-23-250 · West Palm Beach, FLThe failure of the pilot to maintain proper alignment with the runway, his failure to perform a go around after recognizing the aircraft was not properly aligned for landing, and his intentionally landing on a taxiway which resulted in a landing overrun and…NTSB DFW05CA096Accident · No injuriesData collectionFinal reportGlaser-Dirks DG 600 · Kent, TXThe pilot's misjudgement of distance and altitude during a cross-country soaring flight. A contributing factor was the lack of suitable terrain for the landing.NTSB SEA05LA066Accident · No injuriesLimited investigationFinal reportAbbott Glasair Legend · Cascade, MTThe accumulation of wet snow on the engine inlet assembly protection screen during a rapid increase in outside air temperature, while on an instrument approach for landing. Factors include falling snow, a sudden and significant increase in outside air…NTSB LAX05LA122Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Prescott, AZThe company mechanic's improper maintenance actions, which resulted in the total failure of the main rotor drive belt system on approach to landing. A factor was the soft terrain.NTSB CHI05LA079Accident · No injuriesLimited investigationFinal reportCessna 210E · Bronson, MIThe pilot's inadequate preflight preparation which failed to detect contaminated fuel that led to a loss of engine power. The unsuitable terrain encountered was a factor.NTSB LAX05LA120Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Carefree, AZthe pilot's improper use of the fuel boost pump contrary to the procedures specified in the pilot owner handbook and other documents.NTSB LAX05LA119Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Waddell, AZthe pilot's failure to maintain adequate rotor rpm and obstacle clearance, resulting in a dynamic rollover and collision with terrain.NTSB LAX05LA118Accident · No injuriesLimited investigationFinal reportCessna 172S · Thermal, CAthe student pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control.NTSB LAX05CA121Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Chandler, AZthe pilot's failure to maintain directional control.NTSB DFW05LA092Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Tontitown, ARThe pilot's falure to maintain airspeed which resulted in an inadvertent stall. A contributing factor was the prevailing tailwind.NTSB DEN05LA063Accident · No injuriesLimited investigationFinal reportMooney M20F · Norwood, COthe reported partial loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ATL05LA065Accident · Serious injuriesLimited investigationFinal reportEmbraer EMB-135LR · Raleigh, NCAn oily smell in the airplane shortly after takeoff for undetermined reasons that resulted in a return to the airport and a passenger injury during the emergency evacuation.NTSB WAS05WA007Accident · Minor injuriesForeign investigationBoeing 707-300 · Entebbe, UgandaNTSB NYC05CA062Accident · No injuriesData collectionFinal reportCessna 150L · Mitchellville, MDThe pilot's inadequate compensation for wind conditions. A factor was the gusty wind conditions.NTSB MIA05LA080Accident · No injuriesLimited investigationFinal reportRobinson R44 · Homestead, FLThe CFI's inadequate supervision of the student during the instructional flight for his failure to stop an excessive rate of descent which resulted in a hard landing following a reported loss of engine power for undetermined reasons.NTSB IAD05LA049Accident · No injuriesLimited investigationFinal reportTaylorcraft F19 · Northampton, MAThe pilot/owner's improper decision to conduct the flight with a known deficiency in equipment, which resulted in a loss of control when the tailwheel springs became disconnected. Factors were the disconnection of the tailwheel springs, the snow bank, and…NTSB IAD05LA046Accident · Serious injuriesLimited investigationFinal reportSchweizer 269C · Leet, WVA fatigue fracture of the main transmission drive pinion. Also causal was the manufacturer's failure to remove the affected pinions from service during the period that transpired between the initial failures and the accident flight.NTSB DFW05WA197Incident · No injuriesForeign investigationBell 412 · Aguas de Dios, ColombiaNTSB DFW05CA090Accident · Minor injuriesData collectionFinal reportCessna 172 · Nachogdoches, TXThe pilot's improper in-flight planning which resulted in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB DEN05LA064Accident · No injuriesLimited investigationFinal reportCessna 177B · Rock Springs, WYthe pilot's improper flare and recovery from a bounced landing.NTSB ATL05CA064Accident · No injuriesData collectionFinal reportPiper PA28-151 · Eastman, GAThe certified flight instructors failure to maintain a visual look out while demonstrating a simulated emergency landing resulting in an in-flight collision with a known transmission wire.NTSB ANC05LA051Accident · No injuriesLimited investigationFinal reportArctic S-1B2 · Anchorage, AKA main landing gear collapse during the landing touch down due to a non-secured clevis bolt at the common attach point on the landing gear oleo shock.NTSB ANC05CA050Accident · Minor injuriesData collectionFinal reportPiper PA-18 · False Pass, AKThe pilot's inadequate compensation for the wind conditions during the initial climb after takeoff, which resulted in a collision with the ground and subsequent nose over. Factors contributing to the accident were a downdraft, and the pilot's inadequate…NTSB MIA05LA081Accident · No injuriesLimited investigationFinal reportBeech C-45H · Panama City, FLThe overload failure of the left main landing gear for undetermined reasons during the landing roll resullting in collapse of the left main landing gear.NTSB DFW05CA098Accident · No injuriesData collectionFinal reportAir Tractor AT-602 · Crosbyton, TXThe pilot's failure to mantain directional control during take-off. A contributing factor was the dust devil.NTSB DFW05CA093Accident · Minor injuriesData collectionFinal reportCessna 172M · Spring, TXThe pilot's inadequate use of carburetor heat, which resulted in carburetor ice and the loss of engine power. A contributing factor was conditions conducive to carburetor icing.NTSB DFW05CA091Accident · No injuriesData collectionFinal reportCessna 172N · Rio Grande City, TXThe pilot's failure to maintain clearance from objects, and his improper compensation for wind conditions while landing. A contributing factor was the gusty wind condition.NTSB DCA05WA046Incident · No injuriesForeign investigationBoeing 717-200 · Launceston, AustraliaNTSB ATL05CA063Accident · Minor injuriesData collectionFinal reportCessna 175 · Charlotte, NCThe pilot's failure to follow the checklist by his failure to verify the fuel selector was in the on position which resulted in fuel starvation and the loss of engine power.NTSB NYC05LA061Accident · No injuriesLimited investigationFinal reportBoeing 737-72T · Newark, NJThe Boeing flightcrew's misjudged clearance of the parked Gulfstream during taxi, which resulted in a ground collision.NTSB IAD05LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Port Royal, VAA loss of engine power due to the pilot's inadequate preflight planning which resulted in fuel exhaustion.NTSB LAX05LA116Accident · No injuriesLimited investigationFinal reportPiper PA-46-500TP · Flagstaff, AZthe loss of directional control during landing for undetermined reasons.NTSB DEN05CA062Accident · No injuriesData collectionFinal reportBeech A36 · Farmington, NMthe student pilot's failure to maintain airspeed which resulted in a stall and loss of control. Contributing factors were wind gusts, instructor's delay in taking remedial action, and the instructor's inadequate supervision of the flight.NTSB ANC05CA071Accident · No injuriesData collectionFinal reportAerospatiale AS350-B2 · Valdez, AKThe pilot's failure to maintain clearance from an object while hover taxiing, which resulted in the main rotor blades striking a sign.NTSB ANC05CA049Accident · No injuriesData collectionFinal reportBell 206B · Elim, AKThe pilot's continued flight into adverse weather conditions, and his failure to maintain adequate clearance while maneuvering, which resulted in an in-flight collision with terrain. Factors associated with the accident are flat light, whiteout conditions,…NTSB NYC05LA060Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Millersburg, OHThe pilot's inadequate preflight which resulted in a loss of engine power due to fuel contamination. A factor in the accident was the deteriorated fuel cap seals.NTSB LAX05LA115Accident · No injuriesLimited investigationFinal reportSukhoi SU-26 · Tucson, AZthe pilot's inadequate in-flight planning and fuel consumption calculations, which resulted in fuel exhaustion.NTSB DCA05WA043Incident · Minor injuriesForeign investigationBoeing B767 · Buenos Aires, ArgentinaNTSB SEA05LA065Accident · No injuriesLimited investigationFinal reportMaule M-7-235C · Graham, WAThe failure of the right main gear due to separation of the attachment hardware.NTSB SEA05LA064Accident · No injuriesLimited investigationFinal reportCessna 182Q · Shelton, WAThe pilot's improper flare which resulted in a hard landing.NTSB SEA05CA059Accident · No injuriesData collectionFinal reportCessna 182A · Manzanita, ORThe pilot's inadequate compensation for the wind, which resulted in an inflight loss of control, a subsequent uncontrolled descent into the tree stump and guy wire, and the resultant nose over. A factor contributing to the accident was the downdraft.NTSB NYC05FA058Accident · 3 fatalField investigationFinal reportGrumman American AA-5 · Chesapeake, OHThe pilot's failure to maintain airspeed during the aborted landing, which resulted in an inadvertent stall.