Skip to content

NTSB investigations, 2014

17 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") = 2014 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\") = 2014
    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") = 2014
  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 ERA15WA207Accident · No injuriesForeign investigationBeech B300 · Samara, RussiaOn November 25, 2014, about 1852 universal coordinated time, a Beechcraft Corporation B300, Russian registration RA-02778, was substantially damaged when it landed with the landing gear retracted and slid off the runway at Kurumoch International Airport…Nov 25, 2014 · RA-02778 · Substantial damage NTSB CEN15CA033Accident · No injuriesData collectionFinal reportPiper PA-23-250 · Quincy, ILThe pilot's improper fuel management, which resulted in the total loss of power to both engines due to fuel exhaustion and the subsequent forced landing in a field. Also causal to the accident was the pilot's decision to use the slower emergency hand-pump to…Oct 26, 2014 · N62791 · Substantial damage NTSB CEN15CA049Accident · No injuriesData collectionFinal reportCessna 210 · Kalamazoo, MIThe pilot's failure to ensure that the landing gear was fully extended in the down and locked position prior to touchdown, which resulted in the left main landing gear collapse, runway excursion, and impact with a runway exit sign.Oct 24, 2014 · N8219M · Substantial damage NTSB WPR15IA035Incident · No injuriesIncident investigationFinal reportNorth American P51 - D · Mesa, AZThe failure of the left main landing gear to extend, which resulted in a gear-up landing. The reason for the left main landing gear’s failure to operate normally could not be determined because postincident examination of the landing gear system did not…Oct 23, 2014 · N351BD · Minor damage NTSB CEN15IA014Incident · No injuriesIncident investigationFinal reportRaytheon Hawker · Denver, COThe failure of the main landing gear tire, which resulted in separation of the servo block and subsequent total loss of all hydraulic system pressure and prevented the landing gear from extending before landing.Oct 15, 2014 · N694ES · Minor damage NTSB CEN15CA011Accident · No injuriesData collectionFinal reportBeech 35-B33 · Effingham, ILThe pilot's failure to lower the landing gear.Oct 11, 2014 · N718CD · Substantial damage NTSB WPR14CA391Accident · No injuriesData collectionFinal reportPiper PA 31T - II · Oakland, CAThe pilot's failure to extend the landing gear which resulted in a gear-up landing. Contributing to the accident was the pilot's failure to use the checklist and reported stress.Sep 24, 2014 · N774MF · Substantial damage NTSB CEN14LA463Accident · No injuriesLimited investigationFinal reportBeech A36 · Grand Rapids, MIThe pilot’s failure to extend the landing gear before landing.Aug 20, 2014 · N3084Z · Substantial damage NTSB CEN14LA474Accident · No injuriesLimited investigationFinal reportPiper PA 28RT-201T · Houston, TXThe landing gear’s failure to extend for reasons that could not be determined based on the available evidence.Jul 27, 2014 · N2148J · Substantial damage NTSB CEN14LA357Accident · No injuriesLimited investigationFinal reportCessna TR182 · Wichita, KSMaintenance personnel’s improper landing gear system repair, which resulted in a hydraulic leak and subsequent gear collapse during landing.Jul 7, 2014 · N4602S · Substantial damage NTSB CEN14LA354Accident · No injuriesLimited investigationFinal reportBeech A36 · San Antonio, TXThe failure of the landing gear retract rod.Jul 1, 2014 · N136EL · Substantial damage NTSB WPR14CA287Accident · No injuriesData collectionFinal reportMooney M20TN · Yakima, WAThe pilot's failure to configure the landing gear for landing.Jun 28, 2014 · N633GL · Substantial damage NTSB ERA14CA276Accident · Minor injuriesData collectionFinal reportSwearingen SA 226AT · Dayton, TNThe pilot's failure to extend the landing gear during the approach, which resulted in a gear-up landing.Jun 3, 2014 · N120SC · Substantial damage NTSB ERA14CA157Accident · No injuriesData collectionFinal reportCessna 210N · Marathon, FLThe pilot's failure to ensure that the airplane's landing gear was down and locked prior to touchdown. Contributing to the accident was the possibility of intermittent landing gear operation due to a faulty hydraulic power pack contactor.Mar 17, 2014 · N210JZ · Substantial damage NTSB CEN14LA120Accident · No injuriesLimited investigationFinal reportCessna 414A · Ashland, MOThe in-flight failure of both engines due to water contamination.Jan 23, 2014 · N414CJ · Substantial damage NTSB WPR14CA093Accident · Minor injuriesData collectionFinal reportMaule M 7-235 · Lake Havasu, AZThe pilots' failure to verify the landing gear position prior to the water landing and the pilot/examiner's failure to adequately monitor the pilot.Jan 10, 2014 · N6136T · Substantial damage NTSB DCA14WA030Accident · Serious injuriesForeign investigationBoeing 767-3W0ER · Madinah, Saudi ArabiaThe Kingdom of Saudi Arabia, Aviation Investigation Bureau (AIB), has notified the NTSB of an accident involving a Boeing 767-300 that occurred on January 5, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the AIB investigation under…Jan 5, 2014 · HS-BKE · Minor damage