Skip to content

NTSB investigations, 2019

24 cases where the defining event was Landing gear collapse.

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") = 2019 AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '094') 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\") = 2019
    AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '094')
  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") = 2019
  AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '094')
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 DCA20LA047Accident · No injuriesClass 3 · LimitedFinal reportBoeing 737-824 · Denver, COMaintenance personnel’s excessive grinding of the left main landing gear’s aft trunnion pin during its initial overhaul, which caused heat damage to the base metal and led to the fatigue crack that caused the pin to fail during the accident flight.…Dec 23, 2019 · N87513 · Substantial damage NTSB GAA20WA099Accident · No injuriesForeign investigationPiper PA23 · Shannon, IrelandThe government of Ireland has notified the NTSB of an accident involving a PIPER PA23 airplane that occurred on December 02, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's investigation under the provisions…Dec 2, 2019 · EI-WMN · Substantial damage NTSB DCA20WA018Accident · No injuriesForeign investigationBoeing 737 · Bogota, ColombiaThe government of Colombia has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on November 23, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the…Nov 23, 2019 · YV3012 · Substantial damage NTSB DCA20WA030Incident · No injuriesForeign investigationBoeing 737 · Odesa, UkraineThe government of Ukraine has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on November 21, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ukraine's investigation under the provisions…Nov 21, 2019 · TC-JGZ · Minor damage NTSB GAA20CA003Accident · No injuriesData collectionFinal reportVans RV9 · Lake Elsinore, CAThe pilot's selection of unsuitable terrain for taxi, which resulted in the landing gear collapsing and a nose-over.Oct 4, 2019 · N192DP · Substantial damage NTSB ERA19CA291Accident · No injuriesData collectionFinal reportBeech 55 · Sebring, FLThe passenger’s inadvertent retraction of the landing gear during the landing roll without being instructed to do so by the pilot.Sep 13, 2019 · N854T · Substantial damage NTSB ERA19LA279Accident · No injuriesClass 3 · LimitedFinal reportPiper PA23 · Charlotte AmalieThe collapse of the left main landing gear for undetermined reasons.Sep 12, 2019 · N269KW · Substantial damage NTSB ANC19LA047Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-22-150 · Talkeetna, AKA failure of the aft left weld-on fuselage landing gear fitting due to a poor weld joint.Aug 29, 2019 · N7236D · Substantial damage NTSB DCA19WA195Incident · No injuriesForeign investigationBoeing 737 · El Alto, BoliviaThe government of Bolivia has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on August 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bolivia's investigation under the provisions…Aug 3, 2019 · CP-3077 · Minor damage NTSB ANC19LA039Accident · No injuriesClass 3 · LimitedFinal reportCessna 402 · Boise, IDA ductile overstress fracture failure of the right main landing gear bell crank assembly pivot bolt, which resulted in a collapse of the right main landing gear.Jul 22, 2019 · N7947Q · Substantial damage NTSB GAA19WA478Accident · No injuriesForeign investigationBeech C90 · Bucaramanga, ColombiaJul 11, 2019 · N989AE · Substantial damage NTSB WPR19LA180Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28R · Chandler, AZThe pilot's failure to maintain directional control during landing in a gusting right quartering headwind, which resulted in a collapse of the left main landing gear.Jun 30, 2019 · N786N · Substantial damage NTSB WPR19LA169Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Independence, ORFatigue failure of the right landing gear axle, which resulted in a loss of control during the landing roll.Jun 12, 2019 · N73053 · Substantial damage NTSB CEN19LA168Accident · No injuriesClass 3 · LimitedFinal reportRockwell 690 · Jacksonville, FLThe overstress fracture of the roll pin in the nose landing gear (NLG) spacer assembly which caused interference between the nose wheel actuator rod and the left forward gear door actuating rods preventing the NLG to fully extend into the full down and locked…Jun 10, 2019 · N197GB · Substantial damage NTSB GAA19WA597Accident · No injuriesClass 4 · ForeignPiper PA28 · Buenos Aires, ArgentinaJun 9, 2019 · LV-LMG · Substantial damage NTSB GAA19WA541Accident · No injuriesForeign investigationCessna C 680 · Salta, ArgentinaThe government of Argentina has notified the NTSB of an accident involving a CESSNA C 680 airplane that occurred on July 17, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Argentina's investigation under the…Jun 7, 2019 · LV-CIQ · Substantial damage NTSB ERA19LA169Accident · No injuriesClass 3 · LimitedFinal reportHawker Siddeley Hunter · Newport News, VAThe failure of the right main landing gear due to a fatigue cracking.May 9, 2019 · N343AX · Substantial damage NTSB GAA19WA265Accident · No injuriesForeign investigationLearjet 45 · Edinburgh, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a LEARJET 45 airplane that occurred on May 04, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under the…May 4, 2019 · C-GMCP NTSB ERA19LA123Accident · No injuriesClass 3 · LimitedFinal reportBeech A100 · Latrobe, PAA landing gear collapse due to the separation of the actuator pinion bearing support from the actuator, which resulted in the failure of the actuator shaft.Mar 12, 2019 · N945WS · Substantial damage NTSB ERA19LA125Accident · No injuriesClass 3 · LimitedFinal reportPiper PA31 · Leesburg, FLMaintenance personnel’s improper rigging of the main landing gear actuators, which resulted in the collapse of the right main landing gear.Mar 8, 2019 · N45MJ · Substantial damage NTSB DCA19WA099Accident · No injuriesForeign investigationBeech 1900 · Ourgla, AlgeriaThe Civil Aviation Directorate (CAD) of Algeria has notified the NTSB of an accident involving a Beech 1900D, which occurred on March 3, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the CAD investigation under the provisions of ICAO…Mar 3, 2019 · 7T-VIO · Substantial damage NTSB GAA19CA132Accident · No injuriesData collectionFinal reportPiper PA 18A · McGrath, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the landing gear collapsing.Jan 28, 2019 · N8170C · Substantial damage NTSB DCA19WA067Incident · No injuriesForeign investigationBoeing 737 · Ndjili, Congo - KinshasaThe Aviation Accident Investigation Bureau (BPEA) of the Democratic Republic of Congo has notified the NTSB of an incident involving a Boeing 737, which occurred on January 21, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the BPEA…Jan 21, 2019 · 9S-AHJ · Minor damage NTSB WPR19WA113Accident · No injuriesForeign investigationCirrus SR22 · Lanseria, South AfricaOn January 6, 2019, about 0730 coordinated universal time, a Cirrus SR22T, ZS-ARI, experienced a nose landing gear collapse during the landing roll at Lanseria, Gauteng Province, South Africa. The pilot and passenger were not injured. The airplane was…Jan 6, 2019 · ZS-ARI · Substantial damage