Skip to content

NTSB investigations, 2023

37 cases where the sequence of events included Landing gear not configured.

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") = 2023 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '095' 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\") = 2023
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '095' 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") = 2023
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '095' 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 WPR24LA062Accident · Minor injuriesClass 4 · LimitedFinal reportProgressive Aerodyne Searey LSA · Lake Havasu, CAThe pilot’s failure to confirm the landing gear was configured for a water landing during the approach. Contributing to the accident was the pilot’s deviation from the airplanes operating procedures by previously pulling the landing gear circuit breakers,…Dec 28, 2023 · N312PR · Substantial damage NTSB ERA24LA070Accident · No injuriesClass 3 · LimitedFinal reportBeech A24 · Miami, FLA partial loss of engine power during initial climb for undetermined reasons, resulting in a forced landing.Dec 18, 2023 · N52LV · Substantial damage NTSB ERA24LA049Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Valdosta, GAThe pilot’s failure to extend the landing gear before landing.Nov 26, 2023 · N94EM · Substantial damage NTSB ERA24LA037Accident · No injuriesClass 4 · LimitedFinal reportCessna 210 · Frederick, MDA failure of a hydraulic filter, which preluded normal extension of the landing gear. Also causal was the pilot’s failure to confirm that he landing gear was extended before landing, which resulted in a gear up landing.Nov 13, 2023 · N9515X · Substantial damage NTSB ERA24LA041Accident · No injuriesClass 3 · LimitedFinal reportCessna 421 · Lake City, FLA landing gear collapse following an aborted takeoff due to degraded climb performance for reasons that could not be determined.Nov 11, 2023 · N977SM · Substantial damage NTSB ERA24LA034Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32R · Florala, ALThe pilot’s failure to extend the landing gear before landing. Contributing to the accident was the flight instructor’s inadequate supervision of the flight.Nov 8, 2023 · N100VF · Substantial damage NTSB ERA24LA046Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-39 · Highgate, VTThe pilot’s inadvertent retraction of the landing gear during landing rollout, which resulted in a landing gear collapse.Oct 29, 2023 · N289WW · Substantial damage NTSB GAA24WA021IncidentClass 5 · ForeignCessna 525 · Paris, FranceOct 28, 2023 · F-HMSG · Minor damage NTSB CEN24LA026Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-44-180 · Savoy, ILThe pilot’s failure to extend the landing gear before landing and the flight instructor’s inadequate supervision to ensure that the landing gear was extended.Oct 24, 2023 · N5331N · Substantial damage NTSB CEN24LA018Accident · No injuriesClass 3 · LimitedFinal reportCessna 210B · Pueblo, COThe fatigue failure of the right main landing gear hydraulic actuator, which resulted in a loss of hydraulic fluid that prevented the pilot from lowering the landing gear to the fully extended position.Oct 18, 2023 · N9597X · Substantial damage NTSB WPR23LA342Accident · No injuriesClass 4 · LimitedFinal reportCessna T210H · Santa Rosa, CAThe pilot’s failure to configure the landing gear during the landing approach.Sep 6, 2023 · N2210R · Substantial damage NTSB WPR23LA332Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-200T · Coolidge, AZThe pilot's failure to extend the landing gear before landing.Sep 1, 2023 · N440DM · Substantial damage NTSB WPR23LA331Accident · No injuriesClass 4 · LimitedFinal reportBeech N35 · Ennis, MTThe pilot's failure to extend the landing gear before landing.Aug 31, 2023 · N92NJ · Substantial damage NTSB CEN23LA407Accident · No injuriesClass 3 · LimitedFinal reportBeech 95-B55 (T42A) · Greeley, COThe pilot’s failure to extend the landing gear. Contributing to the accident was a malfunction of the landing gear warning horn for undetermined reasons.Aug 30, 2023 · N2KM · Substantial damage NTSB DCA23WA424AccidentClass 5 · ForeignBeech 99 · Black Point, BahamasAug 25, 2023 · C6-FLR NTSB CEN23LA382Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-44-180 · Bonham, TXThe failure of the pilot receiving instruction and flight instructor to follow the landing checklist and extend the landing gear before landingAug 23, 2023 · N7122E · Substantial damage NTSB WPR23LA318Accident · No injuriesClass 4 · LimitedFinal reportCessna T210M · Indian Creek, IDThe pilot's improper fuel management, which resulted in fuel starvation, and gear up landing on a dirt airstrip.Aug 5, 2023 · N7067Z · Substantial damage NTSB DCA23LA409AccidentClass 4 · LimitedFinal reportBoeing 767-322 · Chantilly, VAImproper overhaul of the trunnion cross-pin hole that resulted in the development of stress corrosion cracking and eventual failure of the right forward trunnion.Aug 3, 2023 · N676UA · Substantial damage NTSB ERA23LA300Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA46 · Vineyard Haven, MAThe pilot’s incapacitation due to a sudden in-flight cardiac event, which resulted in a gear-up landing.Jul 15, 2023 · N444RR · Substantial damage NTSB ERA23LA301Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-31-310 · Lumberton, NJThe pilot's failure to extend the landing gear before landing.Jul 14, 2023 · N400S · Substantial damage NTSB CEN23LA298Accident · No injuriesClass 4 · LimitedFinal reportMariner Unknown · Lino Lakes, MNThe pilot’s failure to retract the landing gear on the amphibious airplane before landing on water.Jul 9, 2023 · UNREG · Substantial damage NTSB CEN23LA274Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Durango, COThe pilot’s failure to extend the landing gear before landing.Jul 2, 2023 · N7525P · Substantial damage NTSB DCA23FA339Accident · No injuriesClass 3 · FieldFinal reportBoeing 717-200 · Charlotte, NCA fatigue fracture of the upper lock link that initiated along scratch features on the lower surface at the parting line of the forged aluminum component. Contributing to the accident was the overhaul facilities noncompliance with Service Bulletin 717-32-002.Jun 28, 2023 · N955AT · Substantial damage NTSB GAA23WA186Accident · No injuriesClass 5 · ForeignGulfstream II · Zumpango, MexicoJun 27, 2023 · XC-LPY · Substantial damage NTSB DCA23WA327Accident · No injuriesClass 5 · ForeignBoeing 787 · Taipei, TaiwanJun 18, 2023 · 9V-OJF · Minor damage NTSB WPR23LA234Accident · No injuriesClass 4 · LimitedFinal reportCessna P210N · Olivehurst, CAThe pilot’s failure to extend the landing gear before landing.Jun 10, 2023 · N4761A · Substantial damage NTSB CEN23LA253Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Watkins, COThe pilot’s failure to extend the landing gear before landing. Contributing to the accident was the pilot’s failure to utilize the prelanding checklist to ensure the landing gear was extended before landing.Jun 10, 2023 · N6886P · Substantial damage NTSB ERA23LA262Accident · No injuriesClass 3 · LimitedFinal reportBurton Searey · Sherrills Ford, NCThe pilot’s failure to configure the amphibious airplane’s landing gear before conducting a forced landing to a lake after a loss of engine power. Also causal was the occluded gascolator and the pilot’s lack of knowledge about the airplane’s fuel system,…May 31, 2023 · N2440S · Substantial damage NTSB CEN23LA192Accident · No injuriesClass 4 · LimitedFinal reportNorth American-Buehn T-6G · Ankeny, IAThe pilot’s inadvertent retraction of the landing gear control lever, resulting in a gear-up landing on the runway.May 20, 2023 · N42JM · Substantial damage NTSB ERA23LA237Accident · No injuriesClass 4 · LimitedFinal reportBeech 65-A90-1 · Petersburg, WVThe flight crew’s failure to ensure that the landing gear were properly configured before landing.May 18, 2023 · N80Y · Substantial damage NTSB CEN23LA194Accident · No injuriesClass 3 · LimitedFinal reportBeech 35-C33A · Indianola, MSAn in-flight fire for undetermined reasons.May 18, 2023 · N63B · Destroyed NTSB CEN23LA180Accident · No injuriesClass 4 · LimitedFinal reportSearey LSX · Pottsboro, TXThe pilot’s failure to retract the landing gear before a water landing.May 3, 2023 · N40SR · Substantial damage NTSB ERA23LA210Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · St. Augustine, FLThe pilot’s failure to extend the landing gear before landing.Apr 18, 2023 · N751WW · Substantial damage NTSB ERA23LA179Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-18AS-125 · Lakeland, FLThe pilot’s failure to ensure that the landing gear was properly configured for a water landing.Mar 22, 2023 · N1907A · Substantial damage NTSB CEN23LA116Accident · No injuriesClass 4 · LimitedFinal reportBeech G35 · Grand Prairie, TXThe pilot’s failure to extend the landing gear before landing.Feb 20, 2023 · N4210D · Substantial damage NTSB ERA23LA129Accident · No injuriesClass 4 · LimitedFinal reportCessna TR182 · Chatham, MAThe pilot’s failure to lower the landing gear before touchdown.Feb 19, 2023 · N711PD · Substantial damage NTSB CEN23LA115Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-200T · Cahokia, ILThe pilot’s failure to extent the landing gear before landing.Feb 15, 2023 · N7681F · Substantial damage