Skip to content

NTSB investigations, 2000

18 cases where the first occurrence was “Wheels up landing”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19932026

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") = 2000 AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 232) 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\") = 2000
    AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 232)
  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") = 2000
  AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 232)
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 MIA01LA044Accident · No injuriesLimited investigationFinal reportAero Vodochody Aero. Works L-39C · Hilton Head Isl, SCthe pilot's improper inflight planning/decision and failure to follow the prelanding checklist, resulting in the landing gear not being lowered in sufficient time to be verified down and locked, which resulted in a wheels up landing and substantial damage to…Dec 16, 2000 · N139CG · Substantial damage NTSB DEN01LA008Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Santa Teresa, NMthe pilot's failure to follow procedures/directives and lower the landing gear for landing. Contributing factors were the damaged propellers making it impossible to perform a go-around, the inadvertent stall to the runway, and the pilot being in a state of…Oct 29, 2000 · N5170Y · Substantial damage NTSB DEN00LA179Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Blanding, UTThe pilot's failure to follow the checklist and lower the landing gear for landing. A factor was diverted attention.Sep 27, 2000 · N114SA · Substantial damage NTSB FTW00LA258Accident · No injuriesLimited investigationFinal reportCessna 177RG · Mountain Home, ARThe failure of the landing gear to extend due to the empty hydraulic reservoir.Sep 7, 2000 · N2035Q · Substantial damage NTSB CHI00LA293Accident · No injuriesLimited investigationFinal reportPiper PA28R-200 · Sellersburg, INthe improper servicing of the emergency extension assembly and the gear extension not verified by company maintenance personnel. Factors were the failure of the hydraulic system's motor, normal and emergency gear extension not available to the pilot, and the…Sep 1, 2000 · N1334T · Substantial damage NTSB DEN00LA151Accident · No injuriesLimited investigationFinal reportCessna 310D · Watkins, COThe pilot's failure to follow procedures and lower the landing gear prior to landing. Factors were diverted attention and aural perception.Aug 13, 2000 · N6981T · Substantial damage NTSB DEN00LA142Accident · No injuriesLimited investigationFinal reportMooney M20E · Canon City, COThe pilot's failure to extend the landing gear, which resulted in a wheels up landing.Jul 29, 2000 · N5775Q · Substantial damage NTSB DEN00LA153Accident · No injuriesLimited investigationFinal reportMooney M20C · Erie, COFailure by the pilot to follow procedures and lower the landing gear.Jul 24, 2000 · N5549Q · Substantial damage NTSB LAX00TA263Accident · No injuriesFinal reportCessna 337G · Battle Mountain, NVFailure of the pilot to extend the landing gear, and his failure to follow the published before landing checklist concerning extension of the landing gear.Jul 13, 2000 · N3273D · Substantial damage NTSB NYC00IA150Incident · No injuriesIncident investigationFinal reportBeech 1900D · Rochester, NYThe reversal of landing gear hydraulic lines by company maintenance personnel. Factors related to the incident were the manufacturers omission of maintenance procedures, and the failure of an electrical switch for undetermined reasons.Jun 3, 2000 · N853CA · Minor damage NTSB DEN00LA097Accident · No injuriesLimited investigationFinal reportPiper PA-44-180T · Englewood, COIn-flight planning and decision by the flight instructor by allowing the student to fly into a hazardous situation. Factors were the flight instructor delaying extending the landing gear and delaying a go-around.May 30, 2000 · N8303P · Substantial damage NTSB DEN00LA094Accident · No injuriesLimited investigationFinal reportCessna T210M · Laramie, WYThe pilot-in-command's failure to confirm, the landing gear was down and locked. Factors were the check pilot's failure to confirm the landing gear was down and locked, and the sun glare.May 21, 2000 · N66DF · Substantial damage NTSB ATL00LA050Accident · No injuriesLimited investigationFinal reportCessna 501 · Orlando, FLThe pilot's failure to follow the landing checklist that resulted in the delay of lowering the landing gear before touchdown.May 2, 2000 · N56LW · Substantial damage NTSB CHI00LA116Accident · No injuriesLimited investigationFinal reportBeech 58 · Decatur, ILthe failure of the pilot to extend the landing gear which resulted in the gear-up landing. A factor to the accident was the pilot's failure to complete the landing checklist.Apr 19, 2000 · N9429Q · Substantial damage NTSB CHI00LA102Accident · No injuriesLimited investigationFinal reportBeech A36 · Bloomington, INdirectional control not maintained and maximum gross weight was exceeded by the pilot in command.Mar 31, 2000 · N91TD · Substantial damage NTSB LAX00LA131Accident · No injuriesLimited investigationFinal reportPiper PA-31-T1 · Scottsdale, AZThe pilot's failure to ensure that the landing gear was lowered before touchdown.Mar 20, 2000 · N5WC · Substantial damage NTSB ATL00LA032Accident · No injuriesLimited investigationFinal reportBellanca 260 B · Cornelia, GAThe pilot's failure to use the checklist, resulting in a wheels-up landing and post-crash fire.Mar 5, 2000 · N8865R · Destroyed NTSB FTW00LA078Accident · No injuriesLimited investigationFinal reportSwearingen SA-227-AT · Fayetteville, ARThe flight crew's failure to extend the landing gear. Contributing factors were the flight crew's non-compliance with the checklist, the pilot-in-command's diverted attention as a result of the loss of instrument approach/runway lighting, the partial failure…Jan 29, 2000 · N245DH · Substantial damage