Skip to content

NTSB investigations, 2012

41 cases where the sequence of events included Attempted remediation/recovery.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20082026

Where

Latest cases

Query with SQL

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 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '060' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '060' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '060' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
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 CEN13LA094Accident · No injuriesLimited investigationFinal reportLsa America Allegro · Adrian, MIThe student pilot’s improper flight control input during a go-around and his interference with the flight instructor’s attempted remedial actions.Dec 6, 2012 · N448SS · Substantial damage NTSB CEN13CA084Accident · No injuriesData collectionFinal reportAmerican Champion 8KCAB · Melbourne, ARThe pilot's failure to maintain directional control of the airplane during the landing.Dec 1, 2012 · N63MY · Substantial damage NTSB CEN13LA062Accident · 1 fatalLimited investigationFinal reportJabiru USA Sport J250-SP · Jacksonville, TXThe pilot's failure to maintain adequate airspeed during initial climb following an aborted landing, which resulted in an aerodynamic stall and spin at a low altitude.Nov 18, 2012 · N635J · Substantial damage NTSB WPR13FA037Accident · 2 fatalField investigationFinal reportCessna 421C · Shaver Lake, CAThe pilot's failure to regain airplane control following a sudden rapid descent during cruise, which resulted in an in-flight breakup. Contributing to the accident was the pilot's decision to make the flight with a failed vacuum pump, particularly at high…Nov 11, 2012 · N700EM · Substantial damage NTSB WPR13LA025Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Mariner · Lake Havasu, AZThe pilot’s unintentional and unrecognized entry into a vortex ring state as a result of conducting a course reversal turn into a tailwind while at a low altitude and airspeed, which resulted in an uncontrolled descent into water.Oct 27, 2012 · N2627M · Substantial damage NTSB CEN13CA007Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Eden Prairie, MNThe pilot’s inadequate braking action and decision to abort the landing near the departure end of the runway. Contributing to the accident was the pilot’s attempt to land near the midpoint of the runway.Oct 2, 2012 · N750SR · Substantial damage NTSB ERA12LA571Accident · No injuriesLimited investigationFinal reportBeagle B206 Series 2 · Perry, FLThe pilot’s improper in-flight fuel management, which resulted in fuel starvation and the right engine’s complete loss of power. Contributing to the accident was the pilot’s improper configuration of the airplane following the loss of engine power.Sep 21, 2012 · N26GW · Substantial damage NTSB CEN12LA615Accident · 1 fatalLimited investigationFinal reportGoodyear F2G · Valley City, NDThe pilot’s decision to initiate the aerobatic maneuver at an altitude that did not allow for full recovery of the airplane before ground impact.Sep 7, 2012 · N5577N · Substantial damage NTSB WPR12CA388Accident · Minor injuriesData collectionFinal reportPiggott John H Bearhawk · Sequim, WAThe student pilot's failure to maintain directional control on landing.Sep 2, 2012 · N347JP · Substantial damage NTSB ERA12CA546Accident · No injuriesData collectionFinal reportCessna 172M · Bardstown, KYThe flight instructor's decision to turn the fuel selector to the off position and his delayed remedial actions to restart the engine, which resulted in fuel starvation and a subsequent forced landing.Aug 30, 2012 · N21214 · Substantial damage NTSB ERA12CA523Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-1B · Bedford, PAThe pilot's failure to maintain control of the airplane during the landing and subsequent go-around. Contributing to the accident was the pilot's failure to shutoff the carburetor heat during the attempted go-around and the weight at which the airplane was…Aug 22, 2012 · N9858L · Substantial damage NTSB CEN12IA554Incident · No injuriesIncident investigationFinal reportCessna 560XL · Des Moines, IAA temporary loss of control during cruise flight for reasons that could not be determined because postincident examination of the autopilot, pitch trim systems, and horizontal stabilizer revealed no anomalies consistent with a loss of control.Aug 15, 2012 · N108EK · Minor damage NTSB CEN12LA538Accident · No injuriesLimited investigationFinal reportCantlon Starduster Too SA300 · Galion, OHThe pilot's failure to maintain directional control and a proper pitch attitude and airspeed while performing an aborted landing.Aug 7, 2012 · N111LC · Substantial damage NTSB ERA12CA492Accident · No injuriesData collectionFinal reportFairchild M-62A · Albion, NYThe pilot’s failure to maintain directional control while taking off in gusting wind conditions.Jul 25, 2012 · N53953 · Substantial damage NTSB CEN12CA482Accident · No injuriesData collectionFinal reportNelson Miles Sky Star Kitfox · Weatherford, TXThe pilot's failure to maintain directional control during the landing flare. Contributing to the accident was the pilot’s delay in aborting the landing.Jul 25, 2012 · N4454U · Substantial damage NTSB ERA12LA455Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G 103 Twin II · Hilltown, PAThe improper decision of the flight instructor receiving instruction to attempt a course reversal rather than land straight ahead following a simulated low-level rope break, and the inadequate remedial action of the flight instructor-in-command for allowing…Jul 13, 2012 · N5448G · Substantial damage NTSB WPR12CA284Accident · Minor injuriesData collectionFinal reportCessna 210-5 · West Glacier, MTThe pilot elected to abort the takeoff without sufficient runway available to land and stop the airplane. Contributing to the accident was the illusion created by the rising terrain, which influenced the pilot's decision to abort the takeoff.Jul 2, 2012 · N8450Z · Substantial damage NTSB ERA12CA424Accident · No injuriesData collectionFinal reportBeech 58 · Atlanta, GAThe pilot's inadvertent retraction of the landing gear during the landing.Jul 1, 2012 · N827EB · Substantial damage NTSB CEN12LA408Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Griswold, IAThe pilot’s failure to maintain adequate airspeed during an attempted go-around, resulting in an aerodynamic stall.Jul 1, 2012 · N73182 · Substantial damage NTSB ERA12CA418Accident · Minor injuriesData collectionFinal reportGrumman American Avn. AA-1C · West Chester, PAThe pilot’s failure to maintain directional control during an attempted go-around, which resulted in a runway excursion.Jun 27, 2012 · N9675U · Substantial damage NTSB WPR12CA268Accident · Minor injuriesData collectionFinal reportCessna 182P · Woodland, CAThe pilot's failure to maintain a proper descent path during the approach to land, which resulted in a hard, bounced landing, and his improper retraction of the flaps during the subsequent attempted go-around.Jun 17, 2012 · N7437Q · Substantial damage NTSB ERA12CA404Accident · No injuriesData collectionFinal reportCessna 172K · Tupelo, MSThe pilot's improper recovery from a bounced landing.Jun 15, 2012 · N78794 · Substantial damage NTSB ERA12LA399Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Mariner · Oak Island, NCThe pilot's failure to properly execute the helicopter practice autorotation recovery, which resulted in a collision with the water.Jun 14, 2012 · N1089N · Substantial damage NTSB CEN12LA344Accident · No injuriesLimited investigationFinal reportAir Tractor AT401 · Kenmare, NDThe pilot's failure to maintain directional control during an aborted takeoff.Jun 4, 2012 · N4547Q · Substantial damage NTSB CEN12LA337Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Put-in-Bay, OHThe pilot's failure to attain a proper touchdown point at the proper speed, his failure to initiate a go-around, and the airplane’s inadequate climb gradient after the aborted landing, which resulted in impact with the trees.Jun 4, 2012 · N2434M · Substantial damage NTSB ERA12CA375Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Titusville, FLThe flight instructor’s inadequate supervision and delayed remedial action during a simulated engine-out procedure, which resulted in a hard landing.May 31, 2012 · N1803R · Substantial damage NTSB CEN12LA333Accident · Serious injuriesLimited investigationFinal reportWalters RV-8 · Hutchinson, MNThe pilot's failure to maintain proper airspeed during the landing attempt, his failure to maintain directional control, and his delayed attempted aborted landing at an airspeed that was too low, which resulted in an aerodynamic stall.May 31, 2012 · N808WW · Substantial damage NTSB ANC12CA042Accident · No injuriesData collectionFinal reportBeech 1900C · McGrath, AKThe pilot's unstable approach and overrotation, which resulted in a tailstrike.May 24, 2012 · N111AX · Substantial damage NTSB ERA12FA345Accident · 1 fatalField investigationFinal reportShepard Jimmy D JR Pitts S1D · Port Richey, FLThe pilot's decision to conduct aerobatic flight at a low altitude, which resulted in a collision with the water.May 21, 2012 · N360MW · Substantial damage 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.May 19, 2012 · N74914 · Substantial damage 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.May 17, 2012 · N297SC · Substantial damage NTSB ERA12CA325Accident · Minor injuriesData collectionFinal reportCessna 172R · Culebra, PRThe pilot's failure to remove the flight control lock before takeoff.May 7, 2012 · N24461 · Substantial damage NTSB CEN12LA260Accident · No injuriesLimited investigationFinal reportThrush S2R-H80 · Bryan, TXThe pilot's diverted attention, which resulted in a loss of control while maneuvering the airplane at a low altitude.Apr 25, 2012 · N510KW · Substantial damage NTSB CEN12LA247Accident · No injuriesLimited investigationFinal reportHughes 269A · Grinnell, IAThe pilot's improper liftoff technique, which resulted in ground resonance, and the pilot's delayed recognition of the ground resonance.Apr 17, 2012 · N69HJ · Substantial damage NTSB ERA12CA254Accident · No injuriesData collectionFinal reportFantasy Air Sro Allegro 2007 · Groveland, FLThe pilot's failure to maintain directional control during a go-around maneuver in gusty crosswind conditions.Mar 25, 2012 · N2570C · Substantial damage NTSB ERA12LA233Accident · Serious injuriesLimited investigationFinal reportBoehlke Kevin P 2/3 Scale Jenny · Hannacroix, NYThe non-certificated pilot's improper high-speed taxi test, which resulted in a loss of control and the pilot's subsequent decision to take off to avoid trees. Also causal, was an in-flight magneto failure, which resulted in a partial loss of engine power.…Mar 18, 2012 · N987KB · Substantial damage NTSB ERA12CA204Accident · Serious injuriesData collectionFinal reportAmerican Champion 7GCAA · Bedminster, NJThe pilot receiving instruction’s inadvertent movement of the pitch trim control to the nose-down position while attempting a go-around.Mar 2, 2012 · N518F · Substantial damage NTSB CEN12LA175Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Rapid City, SDThe loss of engine power during climb due to carburetor icing. Contributing to the accident was the limited travel of the carburetor heat valve which prevented application of maximum carburetor heat.Feb 24, 2012 · N20GG · Substantial damage NTSB WPR12CA134Accident · No injuriesData collectionFinal reportBurkhart Grob G-103A Twin II Acro · Dillingham, HIThe student pilot’s inadequate recovery from a bounced landing.Feb 20, 2012 · N103SH · Substantial damage NTSB WPR12LA090Accident · Serious injuriesLimited investigationFinal reportCessna 172E · Dinsmore, CAThe flight instructor's delayed remedial action, inadequate recovery from a bounced landing, and failure to attain/maintain adequate airspeed during an attempted go-around.Feb 3, 2012 · N3879S · Substantial damage NTSB ERA12CA137Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · St Petersburg, FLThe flight instructor's delayed remedial action during the pilot-receiving-instruction's practice autorotation that developed a high rate of descent. Contributing to the accident was the pilot-receiving-instruction's improper control inputs during the…Jan 6, 2012 · N8066U · Substantial damage