NTSB investigations, 2011, FL

33 cases where the phase of flight was Landing.

Cases per year

19622026
NTSB investigations, 2011, FL per year, 1962–2026: 3,027 cases
19624
19633
196477
1965113
196694
1967121
196883
196972
197066
197172
197293
197390
197481
197559
197662
197772
197879
197968
198067
198148
198255
198344
198453
198545
198662
198759
198848
198952
199028
199126
199227
199330
199441
199528
199627
199729
199845
199931
200033
200135
200232
200328
200436
200550
200650
200748
200840
200925
201025
201133
201222
201322
201443
201533
201626
201734
201842
201934
202029
202129
202221
202321
202428
202529
202625

Latest cases

Query with SQL
duckdb -csv -c "WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
    crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
    current_codes AS (
      SELECT e.case_mkey, TRY_CAST(e.\"tier1Number\" AS INTEGER) AS code,
        row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e.\"isDefiningEvent\", false) DESC, e.position) AS n
      FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
      WHERE e.aircrafts_position = 1 AND e.\"tier1Number\" GLOB '[1-9][0-9]*'
        AND (e.\"isDefiningEvent\" OR e.case_mkey IN (SELECT \"mKey\" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE \"isPre1982\"))
    ),
    phases AS (
      SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
      FROM current_codes WHERE n = 1
      UNION ALL
      SELECT o.case_mkey, 'older', o.\"phaseOfFlightCode\", w.main
      FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o.\"phaseOfFlightCode\"
      WHERE o.aircrafts_position = 1 AND o.\"occurrenceNumber\" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
    ),
    case_phases AS (
      SELECT p.*, c.\"eventDate\", c.\"highestInjuryLevel\" = 'Fatal' AS fatal, a.aircraft_model_code
      FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = p.case_mkey
      LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
      WHERE c.\"eventDate\" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
    )
  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.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 550)
  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.

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 damageNTSB ERA12CA076Accident · No injuriesData collectionFinal reportCessna A150M · Ormond Beach, FLThe pilot's inadequate recovery from a bounced landing, which resulted in a loss of airplane control.Nov 17, 2011 · N9890J · Substantial damageNTSB 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 damageNTSB 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 damageNTSB ERA12CA037Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Deland, FLThe pilot's inadequate directional control during the landing roll.Oct 15, 2011 · N929SC · Substantial damageNTSB ERA12CA046Accident · No injuriesData collectionFinal reportCessna 182L · Gainesville, FLThe pilot did not maintain a proper descent rate during the approach, which resulted in a hard landing.Oct 12, 2011 · N42547 · Substantial damageNTSB ERA12CA010Accident · No injuriesData collectionFinal reportCalvin Nate H CALVIN-VELOCITY · Sebastian, FLThe pilot's failure to maintain the proper approach path, which resulted in a runway undershoot and collision with terrain prior to the runway.Oct 6, 2011 · N67WR · Substantial damageNTSB ERA12CA003Accident · Serious injuriesData collectionFinal reportAir Tractor AT-502B · Fort Pierce, FLThe pilot's delayed decision to abort the takeoff.Oct 4, 2011 · N90805 · Substantial damageNTSB ERA11LA519Accident · No injuriesLimited investigationFinal reportHeinlein George GH125 · Okeechobee, FLThe non-certificated pilot's improper flare on an earlier flight, which resulted in a hard landing, fracture of the right main landing gear bolt, and subsequent collapse of the right main landing gear.Sep 19, 2011 · N79GH · Substantial damageNTSB ERA11CA490Accident · No injuriesData collectionFinal reportCessna 172R · Naples, FLThe student pilot's improper flare, which resulted in a hard landing and subsequent loss of directional control.Sep 14, 2011 · N10632 · Substantial damageNTSB ERA11CA487Accident · Serious injuriesData collectionFinal reportKaribian Hurant Thorp T-18 · Panama City, FLThe pilot's selection of an unsuitable landing site, which resulted in a collision with a culvert.Sep 10, 2011 · N407HK · Substantial damageNTSB ERA11LA481Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · St. Petersburg, FLThe commercial pilot's improper recovery from a practice autorotation, resulting in a tailboom strike and subsequent rollover.Sep 3, 2011 · N7197W · Substantial damageNTSB ERA11CA471Accident · No injuriesData collectionFinal reportPayne/Foster Glasair · Ocala, FLThe failure of the tailwheel locking mechanism to remain engaged while landing in a crosswind, which resulted in a loss of directional control and runway excursion.Aug 24, 2011 · N250CH · Substantial damageNTSB ERA11CA402Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Crystal River, FLThe pilot's failure to attain the proper touchdown point, and his improper decision to perform a go-around with a tailwind and insufficient runway remaining.Jul 15, 2011 · N18PE · Substantial damageNTSB ERA11LA397Accident · No injuriesLimited investigationFinal reportGates Lear Jet 35 · Opa-Locka, FLThe flightcrew’s inadvertent encounter with windshear during landing, which resulted in a loss of control.Jul 12, 2011 · N110UN · Substantial damageNTSB ERA11CA382Accident · No injuriesData collectionFinal reportBeech A36 · Wauchula, FLThe pilot's failure to extend the landing gear during the approach.Jul 5, 2011 · N8036V · Substantial damageNTSB ERA11CA338Accident · No injuriesData collectionFinal reportCessna 172R · Naples, FLThe pilot’s improper flare and recovery from a bounced landing.Jun 10, 2011 · N2458G · Substantial damageNTSB ERA11CA329Accident · No injuriesData collectionFinal reportRemos Remos G-3/600 · Apoka, FLThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and collision with a hangar.Jun 5, 2011 · N13GX · Substantial damageNTSB ERA11CA284Accident · No injuriesData collectionFinal reportCessna 172P · Stuart, FLThe student pilot's improper landing flare, which resulted in a hard landing.May 3, 2011 · N88EP · Substantial damageNTSB ERA11CA283Accident · No injuriesData collectionFinal reportCessna 172P · Fort Pierce, FLThe student pilot's improper flare, which resulted in a hard landing.May 3, 2011 · N5460K · Substantial damageNTSB ERA11CA259Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Lake Wales, FLThe pilot’s failure to maintain directional control during the landing roll.Apr 23, 2011 · N57WV · Substantial damageNTSB ERA11CA255Accident · No injuriesData collectionFinal reportBeech F33A · Ocala, FLThe pilot's improper flare which resulted in a hard landing. Contributing to the accident was the pilot's distracted attention due to the electrical system failure.Apr 21, 2011 · N334J · Substantial damageNTSB ERA11CA254Accident · No injuriesData collectionFinal reportFlight Design Ctls · Jacksonville, FLThe student pilot's improper flare, which resulted in a hard landing.Apr 14, 2011 · N178CT · Substantial damageNTSB ERA11CA241Accident · No injuriesData collectionFinal reportCessna 172 · Ft Pierce, FLThe student pilot's inadequate flare which resulted in a hard landing.Apr 12, 2011 · N702GR · Substantial damageNTSB ERA11LA231Accident · No injuriesLimited investigationFinal reportCessna 172RG · Okeechobee, FLThe failure of the main landing gear to lock in the extended position for undetermined reasons and both pilots’ failure to ensure that the landing gear was down and locked prior to landing.Apr 6, 2011 · N5284V · Substantial damageNTSB ERA11LA221Accident · No injuriesLimited investigationFinal reportCessna 310F · Sanford, FLThe failure of the nose landing gear due to inadequate servicing of the nose gear strut reservoir.Apr 1, 2011 · N6781X · Substantial damageNTSB ERA11CA212Accident · No injuriesData collectionFinal reportMooney M20J · St. Petersburg, FLThe pilot’s failure to maintain directional control during a crosswind landing.Mar 25, 2011 · N201ZZ · Substantial damageNTSB ERA11CA192Accident · No injuriesData collectionFinal reportPiper PA28 · Vero Beach, FLThe student pilot's failure to maintain directional control during the landing rollout.Mar 15, 2011 · N9212E · Substantial damageNTSB ERA11CA186Accident · Minor injuriesData collectionFinal reportCessna 182P · Kissimmee, FLThe pilot's failure to maintain directional control during the landing flare.Mar 11, 2011 · N8033M · Substantial damageNTSB ERA11CA147Accident · No injuriesData collectionFinal reportCessna 172S · Daytona Beach, FLThe pilot's inadequate flare that resulted in a hard landing.Feb 15, 2011 · N378FA · Substantial damageNTSB ERA11CA153Accident · No injuriesData collectionFinal reportOtterback Nicholas J Lightning · Crescent City, FLThe pilot's inadequate flare and failure to recover from a bounced landing which resulted in a runway excursion.Jan 30, 2011 · N324AL · Substantial damageNTSB ERA11CA132Accident · No injuriesData collectionFinal reportCessna 172S · St. Petersburg, FLThe student pilot's failure to maintain directional control while attempting to turn the airplane onto a taxiway after landing.Jan 29, 2011 · N6013J · Substantial damageNTSB ERA11CA125Accident · No injuriesData collectionFinal reportCessna 210K · Crestview, FLThe pilot's inability to maintain control of the airplane during landing due to the failure of the right main tire.Jan 26, 2011 · N5767J · Substantial damage