Final NTSB investigations, FL

3,015 cases where the phase of flight was Landing.

Cases per year

19622026
Final NTSB investigations, FL per year, 1962–2026: 3,015 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
202525
202617

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 c.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
    AND c.\"completionStatus\" = 'Completed'
    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 ERA26LA330Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 NG · Leesburg, FLThe instructor’s delayed remedial action during an aborted landing, which resulted in a loss of airplane control.Sep 4, 2026 · N686MF · Substantial damageNTSB ERA26LA299Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Lakeland, FLAn in-flight collision with a bird while on approach.Jul 24, 2026 · N905KS · Substantial damageNTSB ERA26LA267Accident · Minor injuriesClass 4 · LimitedFinal reportStits Playmate · Green Cove Springs, FLThe pilot’s improper landing flare, which resulted in a hard landing.Jul 9, 2026 · N21JB · Substantial damageNTSB ERA26LA238Accident · No injuriesClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P-MENTOR · Pompano Beach, FLThe student pilot’s improper landing flare, which resulted in a hard landing, and the flight instructor’s delayed remedial action.Jun 9, 2026 · N410UV · Substantial damageNTSB ERA26LA318Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Homestead, FLThe pilot’s excessive braking during the landing roll, which resulted in a nose over.May 30, 2026 · N77061 · Substantial damageNTSB ERA26LA235Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Bartow, FLThe pilot’s failure to extend the landing gear before landing.May 23, 2026 · N5376P · Substantial damageNTSB ERA26LA189Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-220T · Kissimmee, FLFracture of the left main landing gear trunnion during landing, which resulted in a loss of directional control during landing and subsequent runway excursion.Apr 24, 2026 · N6XT · Substantial damageNTSB ERA26LA184Accident · Minor injuriesClass 4 · LimitedFinal reportMaule M-7-260C · Tampa, FLThe pilot’s failure to maintain directional control of the airplane during the aborted landing, which resulted in a runway excursion, collision with a runway sign, and nose over.Apr 23, 2026 · N41S · Substantial damageNTSB ERA26LA182Accident · No injuriesClass 4 · LimitedFinal reportDonald E Johnston Velocity XL-RG · Crestview, FLThe pilot’s failure to extend the landing gear before landing.Apr 17, 2026 · N621CM · Substantial damageNTSB ERA26LA203Accident · No injuriesClass 4 · LimitedFinal reportCessna 182Q · Lutz, FLThe student pilot’s improper landing flare and the flight instructor’s inadequate remedial action, which resulted in a hard landing.Apr 12, 2026 · N759AP · Substantial damageNTSB ERA26LA146Accident · No injuriesClass 4 · LimitedFinal reportSchroder David Lancair IV-P · Feather Sound, FLThe pilot's failure to extend the landing gear before landing.Mar 8, 2026 · N366TF · Substantial damageNTSB ERA26LA139Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-200 · St. Augustine, FLThe pilot's failure to extend the landing gear before landing.Mar 5, 2026 · N44443 · Substantial damageNTSB ERA26LA112Accident · No injuriesClass 4 · LimitedFinal reportBeech B19 · Umatilla, FLThe failure of the right main landing gear during the landing roll, which resulted in a loss of control on the ground and collision with an airport sign.Feb 9, 2026 · N245MJ · Substantial damageNTSB ERA26LA126Accident · No injuriesClass 4 · LimitedFinal reportCessna 172RG · Pembroke Pines, FLThe pilot's failure to extend the landing gear before landing.Feb 1, 2026 · N949SM · Substantial damageNTSB ERA26LA100Accident · No injuriesClass 4 · LimitedFinal reportBell 47G-3B · Floral City, FLThe student pilot’s loss of helicopter control during landing.Jan 29, 2026 · N347BH · DestroyedNTSB ERA26LA090Accident · No injuriesClass 4 · LimitedFinal reportDevesh Tiwary Lightning XS · New Port Richey, FLThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and collision with terrain.Jan 7, 2026 · N929XS · Substantial damageNTSB ERA26LA087Accident · No injuriesClass 4 · LimitedFinal reportCessna 414A · Tampa, FLThe pilot’s failure to secure a bottle, which restricted movement of the right rudder pedal during landing.Jan 5, 2026 · N140KM · Substantial damageNTSB ERA26LA075Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1C-200 · Hawthorne, FLThe pilot’s failure to maintain an appropriate descent rate for a glassy water landing, which resulted in a hard landing.Dec 20, 2025 · N656B · Substantial damageNTSB ERA26LA074Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Fort Lauderdale, FLThe student pilot’s improper landing flare and the flight instructor’s inadequate remedial action, which resulted in a hard landing and subsequent nose landing gear collapse.Dec 16, 2025 · N472A · Substantial damageNTSB ERA26LA060Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters Carbon Cub FX2 · Okeechobee, FLThe pilot’s failure to maintain directional control while landing in a crosswind.Nov 28, 2025 · N711 · Substantial damageNTSB ERA26LA053Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-23-250 · Clewiston, FLThe pilot’s failure to maintain directional control of the airplane during the landing roll.Nov 23, 2025 · N914CC · Substantial damageNTSB ERA26LA045Accident · No injuriesClass 4 · LimitedFinal reportBeech 95 · Edgewater, FLThe pilot’s failure to extend the landing gear prior to landing.Nov 14, 2025 · N2033C · Substantial damageNTSB ERA26LA002Accident · No injuriesClass 4 · LimitedFinal reportMaule M-7-260 · Parkland, FLThe pilot’s failure to retract the amphibious airplane’s landing gear before conducting a forced landing on the water, which resulted in a nose over.Oct 4, 2025 · N368FS · Substantial damageNTSB ERA25LA364Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · Merritt Island, FLThe pilot’s failure to maintain directional control while landing in a crosswind.Sep 20, 2025 · N3429Z · Substantial damageNTSB ERA25LA335Accident · No injuriesClass 4 · LimitedFinal reportLafferty Jack SEA REY · Bell, FLThe pilot’s failure to raise the landing gear before landing on the water.Sep 6, 2025 · N2469J · Substantial damageNTSB ERA25LA323Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Spring Hill, FLThe pilot’s improper landing flare, which resulted in a hard, bounced landing and substantial damage to the airplane’s fuselage.Aug 22, 2025 · N2460A · Substantial damageNTSB ERA25LA343Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-B55 (T42A) · St. Petersburg, FLThe pilot’s failure to extend the landing gear prior to landing. Contributing to the accident was a malfunction of the landing gear’s electrical retraction/extension system, which tripped the circuit breaker.Aug 20, 2025 · N8313N · Substantial damageNTSB ERA25LA314Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32R · Miami, FLAn inflight loss of hydraulic fluid from the landing gear system through a cracked fitting, which resulted in a landing gear collapse upon touchdown.Aug 20, 2025 · N990DM · Substantial damageNTSB ERA25LA319Accident · No injuriesClass 4 · LimitedFinal reportWaco UBF · Tampa, FLThe pilot’s failure to maintain directional control during landing roll, which resulted in a runway excursion and collision with an object.Jul 31, 2025 · N1244G · Substantial damageNTSB ERA25LA263Accident · No injuriesClass 4 · LimitedFinal reportPiper PA34 · Fort Lauderdale, FLThe flight instructor’s inadequate supervision and delayed remedial actions during the landing approach, which resulted in the airplane contacting the runway with the landing gear retracted.Jul 10, 2025 · N1293T · Substantial damageNTSB ERA25LA232Accident · No injuriesClass 4 · LimitedFinal reportScoda Aeronautica Ltda Super Petrel XP · Geneva, FLThe airplane’s collision with a submerged object during landing, which resulted in substantial damage to the fuselage/hull.Jun 8, 2025 · N405XP · Substantial damageNTSB ERA25LA197Accident · No injuriesClass 4 · LimitedFinal reportArlie L Raber III Challenger 1 · Crestview, FLThe pilot’s decision to take off despite having problems controlling the airplane due to his physical stature.May 4, 2025 · N59BR · Substantial damageNTSB ERA25LA180Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8F · Punta Gorda, FLThe pilot’s failure to maintain direction control of the airplane during the landing roll.Apr 13, 2025 · N815B · Substantial damageNTSB ERA25LA168Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-200 · Vero Beach, FLSeparation of the lower nose landing gear down lock link bolt, which resulted in a collapse of the nose landing gear during landing.Apr 4, 2025 · N333SE · Substantial damageNTSB ERA25LA192Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Fort Myers, FLThe pilot’s failure to maintain directional control of the airplane while landing in gusting crosswind conditions, which resulted in the left wing impacting the runway.Mar 28, 2025 · N65011 · Substantial damageNTSB ERA25LA148Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Brooksville, FLThe pilot’s improper landing flare, which resulted in a hard, bounced landing and substantial damage to the airplane’s fuselage.Mar 9, 2025 · N740SP · Substantial damageNTSB ERA25LA208Accident · No injuriesClass 4 · LimitedFinal reportWagoner Richard Searey · Zellwood, FLThe pilot’s inadequate compensation for gusting wind conditions, which resulted in a hard landing.Mar 4, 2025 · N19535 · Substantial damageNTSB ERA25LA140Accident · No injuriesClass 4 · LimitedFinal reportCessna 120 · Arcadia, FLThe pilot’s failure to maintain directional control while landing.Feb 28, 2025 · N3080N · Substantial damageNTSB ERA25LA131Accident · No injuriesClass 4 · LimitedFinal reportMallory Horton AQUA-BEE · Miami, FLThe pilot’s failure to lower the landing gear before touchdown.Feb 25, 2025 · N799RX · Substantial damageNTSB ERA25LA125Accident · No injuriesClass 4 · LimitedFinal reportC K ING Adventure CCX-2000 · Okeechobee, FLA separation of the left main landing gear during landing.Feb 23, 2025 · N63CK · Substantial damageNTSB ERA25LA124Accident · Minor injuriesClass 4 · LimitedFinal reportDecker Daniel B Searey · Tavares, FLThe pilot’s improper flare during a bounced water landing, which resulted in a nose-down and submersion of the airplane’s open cockpit in the water.Feb 23, 2025 · N40DJ · Substantial damageNTSB ERA25LA109Accident · Serious injuriesClass 4 · LimitedFinal reportNear William J RV-7A · Weirsdale, FLThe pilot’s improper landing flare, which resulted in a hard, bounced landing and subsequent nose over.Feb 5, 2025 · N811WJ · Substantial damageNTSB ERA25LA059Accident · No injuriesClass 4 · LimitedFinal reportBell 206B · Lakeland, FLThe pilot’s failure to maintain yaw control during a tailwind approach, which resulted in a loss of tail rotor effectiveness, an uncommanded spin, and subsequent hard landing.Nov 21, 2024 · N422RH · Substantial damageNTSB ERA25LA054Accident · No injuriesClass 4 · LimitedFinal reportJolly Warren T Bakeng Duce · Plant City, FLFailure of the right main landing gear attachment bolt and hold-down nut, resulting in the right main landing gear collapsing.Nov 17, 2024 · N72WJ · Substantial damageNTSB ERA25LA068Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 42 NG · Daytona Beach, FLThe maintenance technician’s failure to follow the manufacturer’s recommended procedures during a wheel and tire change to ensure proper clearance of the tire to the wheel well resulting in the right main wheel becoming stuck in the well and subsequent…Nov 15, 2024 · N508PA · Substantial damageNTSB ERA25LA074Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Palm Beach Gardens, FLThe pilot’s failure to maintain directional control of the airplane during landing in a gusting crosswind, which resulted in a hard landing and runway excursion.Nov 13, 2024 · N6294C · Substantial damageNTSB ERA25LA039Accident · No injuriesClass 4 · LimitedFinal reportCessna T240 · Fort Myers, FLThe pilot’s inadequate compensation for the prevailing wind conditions while landing, which resulted in a runway excursion and collision with a sign.Oct 26, 2024 · N94981 · Substantial damageNTSB ERA24LA399Accident · No injuriesClass 3 · LimitedFinal reportBell Textron Canada 505 · Marianna, FLThe student pilot’s failure to maintain rotor rpm during a simulated autorotation, which allowed for a resonance phenomenon to develop. Contributing to the accident was the flight instructor’s inadequate monitoring of the student pilot’s collective control…Aug 23, 2024 · N945TC · Substantial damageNTSB ERA24LA348Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Orlando, FLThe student pilot's failure to maintain directional control during while landing with a crosswind. Contributing was the instructor’s delayed remedial action.Aug 16, 2024 · N61859 · Substantial damageNTSB ERA24LA347Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Gainesville, FLThe separation of a nose landing gear axle retaining nut and the subsequent the failure of the nose landing gear during landing.Aug 16, 2024 · N6495G · Substantial damage