NTSB investigations: Beech A36
14 cases on aircraft the registry lists as Beech A36, where the sequence of events included Landing gear not configured. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 2011 | 1 |
|---|---|
| 2012 | 3 |
| 2014 | 2 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2023 | 1 |
| 2024 | 2 |
| 2025 | 2 |
Where
Open the mapLatest cases
Query with SQL
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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151604')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND 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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151604')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND 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" DESCRun 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 CEN26LA028Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Hondo, TXThe pilot’s failure to extend the landing gear before landing due to distraction and his failure to conduct the Before Landing checklist.NTSB GAA25WA230AccidentClass 5 · ForeignBeech A36 · Montevideo, UruguayNTSB CEN24LA348Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Amarillo, TXThe pilot’s failure to extend the airplane’s landing gear before landing.NTSB ERA24LA226Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Griffin, GAThe pilot’s failure to extend the airplane’s landing gear before landing.NTSB ERA24LA049Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Valdosta, GAThe pilot’s failure to extend the landing gear before landing.NTSB ERA20CA203Accident · No injuriesClass 4 · Data collectionFinal reportBeech 36 · Batavia, NYThe pilot's failure to extend the landing gear during a precautionary landing after an electrical failure.NTSB GAA20CA022Accident · No injuriesData collectionFinal reportBeech 36 · Douglas, GAThe pilot's failure to extend the landing gear due to intoxication during an unauthorized flight.NTSB GAA18CA412Accident · No injuriesData collectionFinal reportBeech A36 · Spencer, IAThe pilot’s failure to extend the landing gear before landing. Contributing to the accident were the pilot’s failure to use the Before Landing checklist due to being distracted while communicating with other aircraft and controlling the airplane in the…NTSB CEN14LA463Accident · No injuriesLimited investigationFinal reportBeech A36 · Grand Rapids, MIThe pilot’s failure to extend the landing gear before landing.NTSB CEN14LA354Accident · No injuriesLimited investigationFinal reportBeech A36 · San Antonio, TXThe failure of the landing gear retract rod.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.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.NTSB CEN12LA434Accident · No injuriesLimited investigationFinal reportBeech A36 · New Orleans, LAThe pilot's failure to lower the landing gear before touchdown.NTSB ERA11CA382Accident · No injuriesData collectionFinal reportBeech A36 · Wauchula, FLThe pilot's failure to extend the landing gear during the approach.