NTSB investigations, 2012
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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\") = 2012 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") = 2012 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 WPR12LA217Accident · Serious injuriesLimited investigationFinal reportJackson TOP DOG · Apple Valley, CAA loss of engine power during the initial climb for reasons that could not be determined because the anomalies revealed during the postaccident examination would not have necessarily precluded normal operation. Contributing to the accident was the inadequate…NTSB ERA12WA372Accident · 1 fatalForeign investigationCessna 182 · Veronica, ArgentinaOn May 19, 2012, about 2140 universal coordinated time, a Cessna 182C, Argentina registration LV-GTF, was substantially damaged when it impacted terrain during a missed approach at Veronica Airfield, Veronica, Buenos Aires, Argentina. The foreign certificated…NTSB ERA12LA360Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Kingston, NYThe pilot’s failure to maintain adequate clearance from trees/foliage at an undetermined point during the flight.NTSB ERA12LA346Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 · Destin, FLThe partial loss of engine power due to a stuck (open) exhaust valve in the No. 5 cylinder. Contributing to the accident was the operator’s failure to follow the engine manufacturer’s directives concerning cooling of the engine after flight.NTSB ERA12CA357Accident · No injuriesData collectionFinal reportHughes TH-55 · Pittsfield, PAThe student pilot's failure to maintain helicopter control during an encounter with loss of tail rotor effectiveness.NTSB ERA12CA350Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Norwich, NYThe pilot's inability to maintain directional control during a landing with a deflated left main landing gear tire.NTSB ERA12CA348Accident · Minor injuriesData collectionFinal reportMooney M20C · Pembroke Pines, FLThe pilot's improper fuel management, which resulted in a total loss of engine power during approach due to fuel exhaustion.NTSB ERA12CA344Accident · No injuriesData collectionFinal reportCessna 170B · Winterville, NCThe pilot's excessive bank at low altitude, which resulted in an aerodynamic stall.NTSB DCA12WA085Incident · No injuriesForeign investigationBoeing 737 · Riga, LatviaOn May 19, 2012, at approximately 0819 locat time, a Boeing 737-500 operated by AirBaltic was climbing after departure from Riga International Airport, and was cleared by ATC to climb to FL230. At the same time, an Airbus 320, operated by Aeroflot perfromed a…NTSB CEN12LA310Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Humnoke, ARThe pilot’s failure to attain the proper touchdown point, which resulted in a landing undershoot.NTSB CEN12LA309Accident · Minor injuriesLimited investigationFinal reportQuicksilver Sprint II · Lebanon, ILThe total loss of engine power due to a fatigue failure of the crankshaft, attributed to the relative movement between the crankshaft and flywheel assembly.NTSB CEN12LA307Accident · 1 fatalLimited investigationFinal reportDial David L Titan Tornado II · Checotah, OKThe noncertificated pilot's loss of airplane control while maneuvering during initial climb, which resulted in an aerodynamic stall and impact with terrain. Contributing to the accident was the pilot’s ostentatious display.NTSB WPR12FA216Accident · 2 fatalField investigationFinal reportAero Vodochody L-39 · Boulder City, NVAn in-flight emergency followed by a collision with terrain for reasons that could not be determined because postaccident examination of the airframe, engine, and forward and aft canopies revealed no evidence of mechanical malfunctions or failures that would…NTSB ERA12LA343Accident · No injuriesLimited investigationFinal reportCessna 195A · Tipton, PAA fatigue failure of a copper oil line, which resulted in a partial loss of engine power due to oil starvation.NTSB ERA12CA352Accident · Serious injuriesData collectionFinal reportSchempp-Hirth Ventus 2CT · Duncansville, PAThe glider’s encounter with atmospheric lift conditions not sufficient to clear terrain, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's decision to continue turning toward a ridgeline.NTSB DCA12FA076Accident · 1 fatalField investigationFinal reportHawker Hawker Hunter MK.58A · Point Mugu, CAthe pilot's decision to continue the flight with a known fuel imbalance condition that resulted in a loss of lateral control when the imbalance exceeded the known capabilities of the airplane. The fuel imbalance was due to incomplete refueling and an…NTSB WPR12LA214Accident · Serious injuriesLimited investigationFinal reportMarley Kolb Firestar II · Cedar Fort, UTThe pilot's failure to maintain airplane control while on approach for landing in gusting wind conditions.NTSB WPR12CA213Accident · No injuriesData collectionFinal reportRotherwick HR Glasair III · Darby, MTThe pilot’s loss of directional control during an emergency landing on a paved highway.NTSB ERA12CA342Accident · No injuriesData collectionFinal reportPiper PA46 · Springfield, VTThe pilot's failure to maintain directional control while landing in gusting wind conditions.NTSB ERA12CA341Accident · Minor injuriesData collectionFinal reportCzech Sport Aircraft A S Sportcruiser · Shirley, NYThe pilot's failure to maintain airplane control after the cockpit canopy opened during the takeoff climb. Contributing to the accident was the pilot’s failure to securely lock the canopy before takeoff.NTSB DCA12WA081Accident · No injuriesForeign investigationBoeing 737-800 · Dusseldorf, GermanyThe German Federal Bureau of Aircraft Accidents (BFU) has notified the NTSB of an accident involving a Boeing 737 that occurred on May 17, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the BFU investigation under the provisions of…NTSB CEN12LA335Accident · No injuriesLimited investigationFinal reportShort Bros Shorts SD3-60 · Houston, TXThe pilots’ improper decision to burn fuel during the taxi by operating the engines at a higher-than-normal power setting and using the wheel brakes to control taxi speed, which resulted in a wheel fire.NTSB CEN12CA328Accident · No injuriesData collectionFinal reportShiver Tailwind W-10 · Pipe Creek, TXAn inadvertent collision with a deer during takeoff and the airplane’s subsequent departure from the runway and impact with a tree.NTSB ERA12CA339Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Gulf Shores, ALThe pilot's inadvertent application of the wheel brakes immediately after landing, which resulted in the airplane nosing over.NTSB DCA12WA080Incident · No injuriesForeign investigationBoeing MD83 · Taipei, TaiwanThe Taiwan Aviation Safety Council (ASC) has notified the NTSB of an accident involving a MD-80 that occurred on May 16, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the ASC investigation under the provisions of ICAO Annex 13 as the…NTSB CEN12WA322Accident · No injuriesForeign investigationRobinson R44 · Juuka, FinlandOn May 16, 2012, about 1850 UTC, a Robinson R44, Finnish registration OH-CKB, owned by Procopter Oy and operated by HeliPro Oy, was substantially damaged during an emergency landing in a forested area while flying on an external load tree trimming operation…NTSB CEN12CA305Accident · No injuriesData collectionFinal reportCessna A185F · Crystal Falls, MIThe pilot's abrupt maneuver to avoid deer that unexpectedly ran into the airplane's path during the landing roll.NTSB CEN12LA306Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Marion, ARThe partial loss of engine power for reasons that could not be determined because examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB WPR12CA206Accident · No injuriesData collectionFinal reportHunter A-20 Vista Cruiser · Molalla, ORThe pilot's failure to maintain clearance from a rock during an off-airport landing.NTSB DCA12WA074Accident · No injuriesForeign investigationDornier 228 · Jomson, NepalThe Nepal Civil Aviation Authority (NCAA) has notified the NTSB of an accident involving a DO-228 that occurred on May 14, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the NCAA investigation under the provisions of ICAO Annex 13 as…NTSB CEN12LA304Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · El Dorado, KSThe pilot's loss of directional control during landing, which resulted in a runway excursion.NTSB CEN12LA302Accident · Serious injuriesLimited investigationFinal reportTroyer Kitfox 3 · Elm Creek, NEThe pilot’s failure to verify the amount of oil in the injection oil reservoir before takeoff, which resulted in an insufficient fuel/oil ratio and subsequent loss of engine power.NTSB CEN12LA299Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Shawnee, OKThe improper installation of the mixture cable by maintenance personnel, which allowed the mixture cable to entangle with the landing gear during gear extension and led to the subsequent loss of engine power.NTSB ANC12CA039Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Talkeetna, AKThe pilot's failure to maintain directional control of the tailwheel-equipped airplane during landing, which resulted in a ground loop. Contributing to the accident was the flight instructor's failure to adequately monitor the landing.NTSB WPR12LA212Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Hillsboro, ORThe flight instructor's improper decision to take off from a hover with low rotor rpm.NTSB WPR12LA211Accident · No injuriesLimited investigationFinal reportBeech F33A · Mobile, AZThe student pilot's failure to maintain directional control during takeoff.NTSB WPR12FA203Accident · 1 fatalField investigationFinal reportM Squared Breese · Whitewater, CAThe pilot’s decision to fly at low altitude in mountainous terrain in the presence of strong wind and turbulence, which resulted in an aerodynamic upset at too low an altitude for recovery.NTSB ERA12WA354Accident · 2 fatalForeign investigationCessna T210M · Manabi Province, EcuadorOn May 13, 2012, about 2030 local time (May 14, 2012, about 0030 coordinated universal time), a Cessna T210M, Mexican registration XB-MPL, was substantially damaged when it impacted terrain in Manabí Province, Ecuador. The pilot and passenger, both of unknown…NTSB ERA12LA335Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · South Canaan, PAThe pilot's delayed decision to abort the takeoff during shifting wind conditions.NTSB ERA12LA332Accident · Serious injuriesLimited investigationFinal reportStinson SR-7B · West Ossipee, NHThe pilot's inadequate application of carburetor heat which resulted in the formation of carburetor ice and a partial loss of engine power.NTSB CEN12LA296Accident · Minor injuriesLimited investigationFinal reportMaule M-7-420AC · Hanover Township, MIA total loss of engine power for reasons that could not be determined during an exhaustive postaccident examination of the engine and its components.NTSB CEN12CA294Accident · Serious injuriesData collectionFinal reportBeckert Bruce A RV-6 · Au Gres, MIThe pilot’s low altitude maneuvering, which resulted in an inadvertent stall and subsequent impact with the water.NTSB ANC12CA047Accident · No injuriesData collectionFinal reportMaule M-4-220C · Sterling, AKThe pilot's failure to use a preflight checklist and subsequent failure to turn on the airplane's fuel supply, which resulted in a loss of engine power due to fuel starvation.NTSB WPR12LA252Accident · No injuriesLimited investigationFinal reportStaudacher Hydroplanes S300X · Ephrata, WAThe pilot’s inadequate landing flare, which resulted in a bounced landing and subsequent loss of directional control.NTSB WPR12LA201Accident · Minor injuriesLimited investigationFinal reportBeech 3NM · Pope Valley, CAA loss of power in one engine during takeoff, which resulted in a forced landing in a vineyard. The reason for the loss of engine power could not be determined from the available evidence.NTSB WPR12LA200Accident · No injuriesLimited investigationFinal reportChampion 7GC · Rexburg, IDA decrease in indicated oil pressure while maneuvering at low altitude for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Also causal was the pilot’s failure to…NTSB WPR12CA202Accident · No injuriesData collectionFinal reportPiper PA-12 · Idaho Falls, IDThe pilot’s improper landing flare, inadequate recovery from a bounced landing, and subsequent failure to maintain directional control.NTSB ERA12LA336Accident · Minor injuriesLimited investigationFinal reportBeech A36TC · Erwin, NCThe partial loss of engine power shortly after takeoff due to fatigue-fractured exhaust valve springs. Contributing to the accident was the mechanic’s decision to install exhaust valve springs with an unknown service history in the engine’s No. 4 cylinder.NTSB ERA12CA382Accident · No injuriesData collectionFinal reportBeech B90 · Savannah, GAThe pilot's failure to maintain adequate visual lookout while taxiing near a hangar, which resulted in airplane's right wingtip impacting the hangar door.NTSB ERA12CA333Accident · Minor injuriesData collectionFinal reportLuttenbacher Kurt Bushby Mustang 2 · Kingstree, SCThe pilot’s failure to maintain airplane control during the approach to landing, which resulted in a collision with terrain short of the runway. Contributing to the accident was the pilot's lack of experience in the airplane.