NTSB investigations: Gates Learjet 35A, FL
5 cases on aircraft the registry lists as Gates Learjet 35A. 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
| 1994 | 1 |
|---|---|
| 1997 | 1 |
| 2000 | 1 |
| 2014 | 1 |
| 2018 | 1 |
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.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5170602'))
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."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5170602'))
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 ERA19LA073Accident · No injuriesClass 3 · LimitedFinal reportLearjet 35 · Key West, FLThe flight crew’s encounter with windshear during the landing flare, which resulted in a hard landing.NTSB ERA14LA111Accident · Serious injuriesLimited investigationFinal reportGates Learjet 35A · Ft. Lauderdale, FLThe pilot’s failure to ensure that the ground power unit was disconnected from the airplane via hand signals from the lineman providing ground services before taxiing, which resulted in an injury to the lineman.NTSB MIA00FA129Accident · 3 fatalField investigationFinal reportLearjet 35A · Marianna, FLthe pilot's failure to maintain control of the airplane while on final approach resulting in the airplane striking trees. Factors in this accident were: improper planning of the approach, and not obtaining the proper alignment with the runway.NTSB MIA97FA213Accident · Minor injuriesField investigationFinal reportGates Learjet 35A · Avon Park, FLa loss of engine power as a result of the thrust reversers being deployed and subsequent in-flight collision was wires. Factors in this accident were the pilot's disregard for procedures, and the improper use of the thrust reversers.NTSB MIA94IA059Incident · No injuriesIncident investigationFinal reportLearjet LR-35A · Key Largo, FLThe failure of the pilot-in-command to maintain the proper glidepath.