NTSB investigations, 2011, FL

13 cases where the phase of flight was Enroute.

Cases per year

19622026
NTSB investigations, 2011, FL per year, 1962–2026: 2,183 cases
19621
19632
196426
196530
196635
196737
196845
196933
197053
197142
197243
197361
197438
197550
197639
197751
197855
197954
198058
198155
198254
198352
198459
198558
198664
198746
198841
198937
199037
199138
199237
199335
199440
199543
199638
199735
199831
199942
200025
200125
200231
200333
200431
200535
200622
200739
200819
200929
201018
201113
201222
201317
201413
201513
201620
201718
201822
201914
202012
202123
202216
202315
202424
202520
202619

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 = 400)
  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 ERA12IA097Incident · No injuriesIncident investigationFinal reportCessna 560XL · Ocoee, FLWater contamination in the pitch trim actuators.Dec 2, 2011 · N576CS · No damageNTSB ERA12LA087Accident · No injuriesLimited investigationFinal reportSmith Miniplane DSA-4 · Hernando, FLThe pilot's failure to apply carburetor heat while descending in conditions conducive to carburetor icing, which resulted in carburetor icing and a subsequent total loss of engine power.Nov 27, 2011 · N1321 · Substantial damageNTSB ERA11CA511Accident · Serious injuriesData collectionFinal reportBoeing 737-823 · Miami, FLThe in-flight encounter with clear air turbulence, which resulted in an injury to a cabin attendant.Sep 29, 2011 · N804NN · No damageNTSB DCA11CA116Accident · Serious injuriesData collectionFinal reportBoeing 737 7H4 · Cape Coral, FLAn encounter with convective turbulence during the descent.Sep 6, 2011 · N936WN · No damageNTSB ERA11CA367Accident · Serious injuriesData collectionFinal reportMcdonnell Douglas MD88 · Miami, FLThe in-flight encounter with convective turbulence, resulting in an injury to a cabin attendant.Jun 22, 2011 · N884DA · No damageNTSB ERA11FA287Accident · 1 fatalField investigationFinal reportCzech Sport Piper Sport · Spring Hill, FLThe pilot's inadvertent application of control inputs that resulted in rapid, right-rolling, negative g-forces during night cruise flight and his subsequent ejection from the airplane. Contributing to the accident was the pilot's decision to fly at night in…May 7, 2011 · N420PS · Substantial damageNTSB ERA11LA282Accident · No injuriesLimited investigationFinal reportPfouts Alfred L Senior Aero SPT D260 · Palm Coast, FLA total loss of engine power for undetermined reasons.May 4, 2011 · N705AP · Substantial damageNTSB OPS11IA428Incident · No injuriesIncident investigationFinal reportCirrus Design SR22 · Orlando, FLThe air traffic controllers’ application of inappropriate separation between the B737 and the Cirrus and their inappropriate use of airborne civilian aircraft for observation of other airborne aircraft. Contributing to the incident was the crew of the B737's…Mar 27, 2011 · N1487C · 2 aircraft · No damageNTSB ERA11LA190Accident · No injuriesLimited investigationFinal reportCessna 182P · Alachua, FLA loss of engine power due to the failure of the camshaft gear teeth and crankshaft gear teeth for undetermined reasons.Mar 15, 2011 · N430ML · Substantial damageNTSB ERA11CA180Accident · Serious injuriesData collectionFinal reportRobinson Helicopter R44 II · Weston, FLThe pilot's failure to maintain adequate altitude and physical alertness which resulted in an in-flight collision with the water. Contributing to the accident was the pilot's fatigue.Mar 5, 2011 · N4168W · Substantial damageNTSB ERA11LA156Accident · No injuriesLimited investigationFinal reportCessna 172G · Clarksville, FLA loss of engine power due to fuel starvation as a result of the owner's improper maintenance of the fuel selector valve, which resulted in a lack of fuel supply from the right fuel tank.Feb 23, 2011 · N3740L · Substantial damageNTSB ERA11LA130Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Cross City, FLA total loss of engine power resulting from the failure of the camshaft due to fatigue cracks. Contributing to the accident was the inadequate quality inspection of the camshaft after initial manufacture.Jan 28, 2011 · N8135B · Substantial damageNTSB ERA11LA112Accident · Serious injuriesLimited investigationFinal reportBeech A23-24 · Venice, FLThe loss of engine power for undetermined reasons.Jan 12, 2011 · N3670Q · Substantial damage