Skip to content

NTSB investigations, 2022

20 cases where the defining event was 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") = 2022 AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '095') 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\") = 2022
    AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '095')
  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") = 2022
  AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '095')
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 WPR23LA033Accident · No injuriesClass 4 · LimitedFinal reportRaytheon A36 · Freeport, ILThe pilot’s failure to extend the landing gear.Oct 5, 2022 · N147DT · Substantial damage NTSB ERA22LA436Accident · No injuriesClass 4 · LimitedFinal reportPiper PA60 · Richmond, KYThe pilot’s failure to extend the landing gear prior to landing.Sep 25, 2022 · N711TL · Substantial damage NTSB WPR22LA353Accident · No injuriesClass 3 · LimitedFinal reportCessna 525B · Pasco, WAThe failure of the pilot to ensure the landing gear was extended before landing. Contributing was the pilot’s failure to fly a stabilized approach, and his configuration of the airplane that prevented activation of the landing gear not extended warning system…Sep 20, 2022 · N528DV · Destroyed NTSB CEN22LA407Accident · No injuriesClass 4 · LimitedFinal reportBeech 36 · Tupelo, MSThe pilot’s failure to extend the landing gear for a landing.Sep 5, 2022 · N7835R · Substantial damage NTSB ERA22LA415Accident · No injuriesClass 4 · LimitedFinal reportCessna T210N · Georgetown, DEThe pilot's failure to extend the landing gear before landing. Contributing to the accident was an inoperative landing gear warning horn.Aug 25, 2022 · N5132C · Substantial damage NTSB ERA22LA408Accident · No injuriesClass 4 · LimitedFinal reportMooney M20E · Hollywood, MDThe pilot's failure to extend the landing gear before landing.Aug 19, 2022 · N7154U · Substantial damage NTSB WPR22LA373Accident · No injuriesClass 4 · LimitedFinal reportCessna 177RG · Avalon, CAThe pilot’s failure to extend the landing gear before landing, resulting in a gear up landing and substantial damage to the airplane’s belly.Aug 18, 2022 · N52946 · Substantial damage NTSB WPR22LA290Accident · No injuriesClass 3 · LimitedFinal reportEADS Socata TBM 700 · Carlsbad, NMThe pilot’s failure to extend the landing gear before landing due to a distraction, which resulted in an impact with the runway.Aug 3, 2022 · N620WG · Substantial damage NTSB ERA22LA367Accident · Minor injuriesClass 4 · LimitedFinal reportVickers-Slingsby T65A · Butler, GAThe pilot’s retraction the landing gear just prior to touchdown on the runway.Jul 16, 2022 · N157HH · Substantial damage NTSB WPR22LA272Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-60-601P · Scappoose, WAThe pilot’s failure to extend the landing gear before landing. Contributing to the accident was the pilot’s failure to utilize a prelanding checklist.Jul 13, 2022 · N601NG · Substantial damage NTSB WPR22LA327Accident · No injuriesClass 4 · LimitedFinal reportConsolidated Aeronautics Lake LA-4-200 · Lodi, CAThe pilot’s premature retraction of the landing gear during a go-around, which resulted in a gear up landing.Jun 22, 2022 · N6150V · Substantial damage NTSB ERA22LA259Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32R-301 · Spencer, VAThe pilot’s failure to extend the landing gear before landing. Contributing to the accident was the pilot’s failure to use the landing checklist.Jun 4, 2022 · N8429X · Substantial damage NTSB ERA22LA246Accident · No injuriesClass 3 · LimitedFinal reportBeech 58 · Perry, GAThe pilot’s failure to properly configure the landing gear before landing.May 28, 2022 · N120PA · Substantial damage NTSB CEN22LA207Accident · No injuriesClass 4 · LimitedFinal reportBellanca Cruisemaster · Gainesville, TXThe pilot’s failure to extend the landing gear before landing due to his distraction with the wind gusts.May 19, 2022 · N7655B · Destroyed NTSB ERA22LA219Accident · No injuriesClass 4 · LimitedFinal reportShort Bros SD3-60 · San Juan, PRThe flight crew’s failure to extend the landing gear before landing.May 3, 2022 · N744LG · Substantial damage NTSB CEN22LA183Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-B55 (T42A) · Wharton, TXThe pilot’s failure to extend the landing gear.Apr 21, 2022 · N66NP · Substantial damage NTSB WPR22LA180Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-24-400 · Benson, AZThe pilot’s failure to lower the landing gear on approach due to distraction.Apr 15, 2022 · N8493P · Substantial damage NTSB CEN22LA169Accident · No injuriesClass 4 · LimitedFinal reportCessna 172RG · Pearland, TXThe flight instructor's failure to extend the landing gear and perform a before landing checklist.Apr 3, 2022 · N5338V · Substantial damage NTSB CEN22LA177Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · McAllen, TXThe pilot’s failure to extend the landing gear due to distraction.Mar 29, 2022 · XB-CMU · Substantial damage NTSB GAA22WA121Accident · No injuriesClass 5 · ForeignPiper PA-30 · Sandown, United KingdomMar 14, 2022 · N8350Y · Substantial damage