Skip to content

NTSB investigations, 2012

26 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") = 2012 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\") = 2012
    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") = 2012
  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 WPR13CA021Accident · No injuriesData collectionFinal reportPiper PA24 · Lake Tahoe, CAThe pilot's failure to ensure that the landing gear was extended before landing.Oct 21, 2012 · N7950P · Substantial damage NTSB ERA13CA028Accident · No injuriesData collectionFinal reportCessna 172RG · Mobile, ALThe pilot’s failure to perform the before landing checklist and extend the landing gear before touchdown. Contributing to the accident was the designated pilot examiner’s inadequate remedial action.Oct 11, 2012 · N4939V · Substantial damage NTSB WPR12CA435Accident · No injuriesData collectionFinal reportPiper PA24 · Madera, CAThe student's and flight instructor’s failure to ensure that the landing gear was extended prior to landing.Sep 20, 2012 · N8648P · Substantial damage NTSB WPR12CA415Accident · No injuriesData collectionFinal reportBeech V35B · Elko, NVThe pilot's failure to extend the landing gear during the aborted takeoff. Contributing to the accident was the pilot's failure to perform a thorough preflight inspection.Sep 8, 2012 · N1129T · Substantial damage NTSB WPR12CA393Accident · No injuriesData collectionFinal reportBeech 95-55 · Spanoway, WAThe pilot’s failure to lower the landing gear prior to landing.Sep 4, 2012 · N4QC · Substantial damage NTSB CEN12CA613Accident · No injuriesData collectionFinal reportBeech A36 · Washington, MOThe pilot raised the landing gear handle instead of the flap handle during a touch-and-go landing, resulting in the collapse of the nose landing gear while accelerating to takeoff.Aug 7, 2012 · N41HC · Substantial damage NTSB CEN12LA473Accident · No injuriesLimited investigationFinal reportCessna TR182 · Steamboat Springs, COThe pilot's failure to extend the landing gear before landing.Jul 24, 2012 · N73VX · Substantial damage NTSB WPR12CA310Accident · No injuriesData collectionFinal reportPiper PA-46 · Delano, CAThe pilot's failure to extend the landing gear before touchdown. Contributing to the accident was the pilot's failure to perform the appropriate checklist due to distractions posed by another airplane inbound to the same airport and a cluttered radio…Jul 17, 2012 · N558RW · Substantial damage NTSB CEN12LA444Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Grand Forks, NDThe pilot receiving instruction's failure to extend the landing gear and the flight instructor's failure to adequately monitor his student's actions during the approach.Jul 15, 2012 · N580ND · Substantial damage NTSB WPR12CA311Accident · No injuriesData collectionFinal reportCessna T210L · Idaho Falls, IDThe pilot’s failure to extend the landing gear before landing. Contributing to the accident was an uncorrected malfunction of the landing gear warning horn system.Jul 12, 2012 · N787AE · Substantial damage NTSB CEN12CA436Accident · No injuriesData collectionFinal reportBeech 58 · Sugar Loaf Mountain, MIThe pilot did not complete the before-landing checklist and, subsequently, failed to extend the landing gear prior to landing. Contributing to the accident was the pilot’s distraction with his passengers’ conversation.Jul 10, 2012 · N2023V · Substantial damage NTSB ERA12LA450Accident · No injuriesLimited investigationFinal reportBeech A36 · Johns Island, SCThe pilot's failure to complete the manual emergency gear extension after a loss of electrical power. Contributing to the accident was the pilot's decision to delegate the landing gear extension to a non-pilot-rated passenger.Jul 9, 2012 · N6672B · Substantial damage NTSB ERA12CA424Accident · No injuriesData collectionFinal reportBeech 58 · Atlanta, GAThe pilot's inadvertent retraction of the landing gear during the landing.Jul 1, 2012 · N827EB · Substantial damage NTSB CEN12CA406Accident · No injuriesData collectionFinal reportPiper PA-24 · Watertown, WIThe pilot’s failure to extend the landing gear before landing.Jul 1, 2012 · N6580P · Substantial damage NTSB CEN12LA434Accident · No injuriesLimited investigationFinal reportBeech A36 · New Orleans, LAThe pilot's failure to lower the landing gear before touchdown.Jun 27, 2012 · N136EH · Substantial damage NTSB CEN12LA387Accident · No injuriesLimited investigationFinal reportCessna R182 · Santa Teresa, NMThe pilot’s failure to ensure that the landing gear was down and locked before landing.Jun 21, 2012 · N4702R · Substantial damage NTSB WPR12CA240Accident · No injuriesData collectionFinal reportCessna P337H · Jerome, IDThe pilot’s failure to extend the landing gear before landing. Contributing to the accident was the pilot's failure to use the checklist before landing.May 30, 2012 · N5KX · Substantial damage NTSB ERA12CA361Accident · No injuriesData collectionFinal reportLydon Patrick F Searey · Sanford, FLThe pilot's failure to ensure that the landing gear was retracted for the water landing.May 24, 2012 · N252JB · Substantial damage NTSB WPR12CA234Accident · No injuriesData collectionFinal reportMurphy Rebel · Hayden Lake, IDThe pilots’ failure to position the landing gear for landing on the water, which resulted in a nose-over.May 3, 2012 · N1076D · Substantial damage NTSB CEN12LA283Accident · No injuriesLimited investigationFinal reportBeech 58 · Sioux Falls, SDThe failure of the normal and emergency landing gear system to fully retract or extend the landing gear for reasons that could not be determined during postaccident examinations, which resulted in a partial gear-up landing.Apr 24, 2012 · N8121R · Substantial damage NTSB DCA12FA058Accident · No injuriesField investigationFinal reportBombardier DHC-8-402 · Houston, TXthe nose landing gear alternate release handle was not pulled with sufficient enough force or distance to release the uplocks and allow extension of the nose landing gear. Contributing to the accident was the dissimilar pull force and pull length set on the…Apr 7, 2012 · N213WQ · Substantial damage NTSB ERA12CA247Accident · No injuriesData collectionFinal reportMooney M20J · Butler, PAThe pilot’s failure to extend the landing gear before landing.Mar 23, 2012 · N58135 · Substantial damage NTSB DCA12WA038Accident · No injuriesForeign investigationFairchild SA-227 · Brisbane, AustraliaThe Australian Transportation Safety Bureau (ATSB) has notified the NTSB of an incident involving a Fairchild SA-227 that occurred on February 14, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB investigation under the…Feb 14, 2012 · VH-UZA · Substantial damage NTSB CEN12CA157Accident · Minor injuriesData collectionFinal reportCessna R182 · Colorado Springs, COThe pilot did not extend the landing gear before landing.Feb 4, 2012 · N2696C · Substantial damage NTSB CEN12CA136Accident · No injuriesData collectionFinal reportMooney M20K · Willmar, MNThe pilot landed without lowering the landing gear.Jan 13, 2012 · N262RW · Substantial damage NTSB WPR12LA097Accident · No injuriesLimited investigationFinal reportBeech 58P · Santa Ana, CAThe pilot’s failure to review or execute any applicable checklist procedures or troubleshoot or take corrective action before landing despite indications that the landing gear was not extended. Contributing to the accident were the pilot’s misunderstanding of…Jan 8, 2012 · N580TC · Substantial damage