Skip to content

NTSB investigations, 2011

230 cases where the sequence of events included Runway excursion.

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") = 2011 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '300' 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\") = 2011
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '300' 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") = 2011
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '300' 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 ERA12CA160Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Raleigh, NCThe pilot's loss of directional control while landing in gusting wind conditions.Dec 30, 2011 · N8330S · Substantial damage NTSB ERA12CA129Accident · Minor injuriesData collectionFinal reportKoth Larry Jabiru Calypso · Mansfield, MAThe pilot did not maintain directional control during landing. Contributing to the accident was the pilot’s not closing the throttle upon landing and his improper adjustment of the airplane’s brakes.Dec 30, 2011 · N344MK · Substantial damage NTSB ERA12FA127Accident · No injuriesField investigationFinal reportCessna 650 · Ft. Lauderdale, FLThe crew's failure to use proper emergency procedures during an uncommanded right roll after takeoff, which led to a forced landing with a quartering tailwind. Contributing to the accident was a faulty right roll spoiler actuator, which allowed the right roll…Dec 28, 2011 · N877G · Substantial damage NTSB CEN12LA113Accident · No injuriesLimited investigationFinal reportCessna 182J · St. Paul, MNThe pilot's decision to land on a runway with a gusting, quartering tailwind and his inadequate compensation for the wind, which resulted in a hard landing.Dec 26, 2011 · N2618F · Substantial damage NTSB ERA12CA118Accident · No injuriesData collectionFinal reportCessna 120 · Montague, MAThe pilot's delay in performing a rejected takeoff after experiencing an intermittent loss of engine power, which resulted in a runway excursion.Dec 17, 2011 · N89809 · Substantial damage NTSB CEN12CA117Accident · No injuriesData collectionFinal reportLuscombe 8E · Atchison, KSThe pilot's inadequate directional control during the landing roll.Dec 17, 2011 · N71911 · Substantial damage NTSB WPR12CA068Accident · No injuriesData collectionFinal reportBeech J35 · Cheyenne, WYThe pilot's inadequate compensation for the crosswind, which resulted in a loss of directional control.Dec 16, 2011 · N8281D · Substantial damage NTSB ERA12CA111Accident · No injuriesData collectionFinal reportErcoupe 415-C · Panacea, FLThe pilot did not attain the proper touchdown point during landing, which resulted in a runway overrun.Dec 16, 2011 · N99576 · Substantial damage NTSB ERA12CA110Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Farmville, VAThe pilot did not maintain the proper approach path, which resulted in a runway undershoot.Dec 16, 2011 · N788SR · Substantial damage NTSB WPR12CA061Accident · No injuriesData collectionFinal reportGrumman AA5 · Furnace Creek, CAThe pilot's improper landing flare, inadequate recovery from a bounced landing, and loss of directional control.Dec 10, 2011 · N28870 · Substantial damage NTSB CEN12LA111Accident · Minor injuriesLimited investigationFinal reportCurtiss Wright P40M · Batavia, OHA loss of engine power due to failure of the engine oil cooler and subsequent oil starvation to the engine.Dec 8, 2011 · N5813 · Substantial damage NTSB CEN12CA099Accident · No injuriesData collectionFinal reportCessna 172N · Wauseon, OHThe student pilot's loss of directional control during landing.Dec 3, 2011 · N737ET · Substantial damage NTSB CEN12FA088Accident · 1 fatalField investigationFinal reportPiper PA-31 · New Orleans, LAThe pilot's fatal cardiac event, which resulted in the inflight loss of control of the airplane. Contributing to the accident was the pilot's use of impairing medications and operation of the airplane with disqualifying medical conditions.Nov 30, 2011 · N6485L · Minor damage NTSB WPR12CA049Accident · No injuriesData collectionFinal reportCessna 172K · Napa, CAThe student pilot's improper landing flare, inadequate recovery from a bounced landing, and loss of directional control.Nov 28, 2011 · N7952A · Substantial damage NTSB DCA12WA019Accident · No injuriesForeign investigationGulfstream American G 1159 · Huambo, AngolaOn November 26, 2011, about 1300 UTC, N811DE, a Grumman G-1159 Gulfstream G-II, a private flight operated by Wings Over Africa, was involved in a runway excursion following a rejected takeoff. None of the 10 persons aboard were injured. The aircraft was…Nov 26, 2011 · N811DE · Substantial damage NTSB ERA12CA075Accident · No injuriesData collectionFinal reportBellanca 17-30A · Pine Mountain, GAThe pilot's inadequate directional control during landing, which resulted in a runway excursion.Nov 18, 2011 · N39836 · Substantial damage NTSB WPR12CA043Accident · No injuriesData collectionFinal reportAmerican Champion 7GCAA · Baker, CAThe pilot's delayed decision to perform an aborted landing.Nov 15, 2011 · N497AC · Substantial damage NTSB WPR12CA038Accident · No injuriesData collectionFinal reportCessna 172S · Phoenix, AZThe student pilot's inadequate directional control during takeoff.Nov 12, 2011 · N24350 · Substantial damage NTSB WPR12CA037Accident · No injuriesData collectionFinal reportCessna 180H · Snohomish, WAThe pilot's decision to land in a high, gusting, variable wind.Nov 11, 2011 · N180LV · Substantial damage NTSB CEN12CA062Accident · Minor injuriesData collectionFinal reportBeech 58 · Connersville, INThe pilot's failure to maintain directional control of the airplane during landing.Nov 11, 2011 · N6685S · Substantial damage NTSB WPR12CA033Accident · No injuriesData collectionFinal reportCasler Scott CX-4 · San Carlos, AZThe pilot's inadequate directional control during takeoff.Nov 9, 2011 · N5089Q · Substantial damage NTSB ERA12LA100Accident · No injuriesLimited investigationFinal reportSigmon Harvey E Vans RV 6 · Abingdon, VAThe failure of the Pitts pilot to see and avoid the RV-6 that had landed ahead. Contributing to the accident was the Pitts pilot's inability to hear the RV-6 pilot's radio calls due to the lack of a radio in the Pitts.Nov 6, 2011 · N62HS · 2 aircraft · Substantial damage NTSB ERA12CA064Accident · No injuriesData collectionFinal reportStinson 108-3 · Whitefield, NHThe student pilot did not maintain directional control during the landing flare.Nov 5, 2011 · N6263M · Substantial damage NTSB ERA12IA060Incident · No injuriesIncident investigationFinal reportCessna 550 · Key West, FLThe pilots’ failure to appropriately apply the landing gear wheel brakes after landing, to properly perform the hard brake pedal-no braking condition procedure following the reported brake failure and to apply the emergency brakes. The reason for the reported…Nov 3, 2011 · N938D · Minor damage NTSB DCA12WA011Incident · No injuriesForeign investigationBoeing 777 · Munich, GermanyOn November 3, 2011, at about 1210 local time (1110 UTC), a Boeing 777-300, 9V-SWQ, experienced a runway excursion upon landing on runway 08R at Franz Joseph Strauss Munich Airport (EDDM), Munich, Germany. None of the 143 passengers or 15 crewmembers were…Nov 3, 2011 · 9V-SWQ · Minor damage NTSB ERA12LA061Accident · Minor injuriesLimited investigationFinal reportCessna 172R · Frederick, MDThe student pilot’s inadequate directional control during the landing roll.Nov 2, 2011 · N212CF · Substantial damage NTSB ERA12FA056Accident · Serious injuriesField investigationFinal reportGulfstream G150 · Key West, FLThe pilot in command's failure to follow the normal landing procedures (placing engines into reverse thrust first and then brake), his delayed decision to continue the landing or go-around, and the flight crew's failure to follow emergency procedures once a…Oct 31, 2011 · N480JJ · Substantial damage NTSB ERA12LA048Accident · No injuriesLimited investigationFinal reportBeech C23 · Columbia, MSThe partial loss of engine power for undetermined reasons during takeoff.Oct 23, 2011 · N89MH · Substantial damage NTSB CEN12CA028Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Brookings, SDThe pilot's inadequate compensation for gusty wind conditions while landing.Oct 18, 2011 · N8485D · Substantial damage NTSB ERA12CA040Accident · No injuriesData collectionFinal reportEngineering & Research 415-C · Mebane, NCThe pilot's delay in aborting the takeoff.Oct 16, 2011 · N3760H · Substantial damage NTSB CEN12CA038Accident · No injuriesData collectionFinal reportPipistrel Sinus 912 · Indianapolis, INThe pilot's failure to maintain directional control of the motor-glider while landing in gusty wind conditions.Oct 16, 2011 · N9013H · Substantial damage NTSB ERA12CA037Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Deland, FLThe pilot's inadequate directional control during the landing roll.Oct 15, 2011 · N929SC · Substantial damage NTSB CEN12CA029Accident · Minor injuriesData collectionFinal reportHunt Sparrowhawk · Blair, NEThe pilot/builder’s inadequate installation of a nosewheel steering component, which resulted in a shimmy and a loss of directional control during the takeoff roll.Oct 15, 2011 · N29HT · Substantial damage NTSB WPR12CA011Accident · Minor injuriesData collectionFinal reportCessna 170B · Ramona, CAThe pilot’s failure to maintain directional control of the airplane during the landing roll.Oct 14, 2011 · N8261A · Substantial damage NTSB CEN12CA027Accident · No injuriesData collectionFinal reportMichael Cans RV-8 · Breaux Bridge, LAThe pilot's failure to maintain control of the airplane after striking an unseen sinkhole during landing.Oct 14, 2011 · N610EC · Substantial damage NTSB CEN12CA011Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Englewood, COThe student pilot's improper flare, which resulted in a bounced landing from which he was unable to recover.Oct 11, 2011 · N777XG · Substantial damage NTSB ERA12CA116Accident · No injuriesData collectionFinal reportCessna 188 · Starkville, MSThe pilot did not maintain directional control of the airplane during landing, which resulted in a runway excursion.Oct 8, 2011 · N5424E · Substantial damage NTSB CEN12LA023Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Wadsworth, OHThe failure of the brake system during the landing roll, which was caused by a loss of hydraulic fluid as a result of a leak in the piston seal due to brake plates worn beyond their service limits.Oct 8, 2011 · N9444W · Substantial damage NTSB CEN12LA013Accident · No injuriesLimited investigationFinal reportWilhelm Calidus · Thompsonville, MIThe pilot 's inability to maintain control of the gyrocraft during the landing roll for undetermined reasons.Oct 7, 2011 · N455BW · Substantial damage NTSB ERA12LA016Accident · No injuriesLimited investigationFinal reportCessna 180J · Norfolk, VAThe pilot's inability to maintain directional control during takeoff for undetermined reasons. Contributing to the accident was the pilot's delayed decision to abort the takeoff.Oct 5, 2011 · N180RN · Substantial damage NTSB CEN11CA675Accident · No injuriesData collectionFinal reportCessna T210R · Lamar, MOThe pilot's inadequate compensation for the wind condition, resulting in a runway excursion.Sep 29, 2011 · N84MC · Substantial damage NTSB WPR11CA466Accident · Minor injuriesData collectionFinal reportCessna 172S · Phoenix, AZThe pilot’s failure to maintain directional control during the landing rollout.Sep 26, 2011 · N169ME · Substantial damage NTSB ANC11CA113Accident · No injuriesData collectionFinal reportPiper PA-12 · Talkeetna, AKThe pilot’s decision to take off from an off-airport site in variable wind.Sep 26, 2011 · N2945M · Substantial damage NTSB WPR11CA465Accident · No injuriesData collectionFinal reportCessna 182 · Roosevelt, UTThe pilot's loss of directional control during the landing rollout.Sep 25, 2011 · N92554 · Substantial damage NTSB CEN11CA665Accident · No injuriesData collectionFinal reportEsselstyn Chuck RV-6 · Lyons, WIThe pilot's failure to obtain a proper touchdown point while landing, which resulted in a runway overrun.Sep 23, 2011 · N6YC · Substantial damage NTSB CEN11CA674Accident · No injuriesData collectionFinal reportCessna 172N · Wadsworth, OHThe pilot's misjudgment of his speed and distance, which resulted in an overrun.Sep 22, 2011 · N9348E · Substantial damage NTSB ERA11IA521Incident · No injuriesIncident investigationFinal reportBeech V35 · New Haven, CTThe in-flight fatigue failure of the engine’s crankshaft, which resulted in the separation of the forward portion of the crankshaft and the propeller.Sep 18, 2011 · N275BM · Minor damage NTSB CEN11LA658Accident · No injuriesLimited investigationFinal reportMark Divita RV-8 · Lancaster, TXThe failure of the tailwheel to remain locked during a crosswind landing, which resulted in a loss of directional control.Sep 18, 2011 · N98D · Substantial damage NTSB CEN11CA668Accident · No injuriesData collectionFinal reportCessna R172K · Jonesboro, ARThe pilot's failure to maintain directional control of the airplane while taxiing.Sep 18, 2011 · N758DZ · Substantial damage NTSB ERA11WA518Accident · No injuriesForeign investigationGates Lear Jet 35 · Valencia, Carabobo, VenezuelaOn September 17, 2011, about 2135 universal coordinated time, a Gates Lear Jet 35, N535LC, was substantially damaged while landing at the Arturo Michelena Airport (SVVA), Valencia, Carabobo, Venezuela. The two pilots and five passengers were not injured. The…Sep 17, 2011 · N535LC · Substantial damage