NTSB investigations: Gates Learjet 25D
8 cases on aircraft the registry lists as Gates Learjet 25D. 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
| 1979 | 1 |
|---|---|
| 1980 | 1 |
| 1983 | 1 |
| 1985 | 1 |
| 1993 | 1 |
| 2001 | 1 |
| 2005 | 1 |
| 2014 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5170514'))
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 ('5170514'))
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 CEN15WA082Accident · 2 fatalForeign investigationGates Learjet 25D · Champoton, MexicoNTSB LAX06CA028Accident · No injuriesData collectionFinal reportLearjet 25D · Sacramento, CAthe pilot's failure to extend the landing gear and to verify they were in the down and locked position prior to touchdown. A related factor was his diverted attention.NTSB CHI01MA163Accident · Serious injuriesMajor investigationFinal reportLearjet 25D · Salina, KSThe PIC's delayed remedial action during the elevator system oscillation, resulting in the failure of the aft elevator sector clevis due to reverse bending fatigue caused by vibration, and subsequent loss of elevator control. Factors contributing to the…NTSB FTW93FA255Accident · 7 fatalField investigationFinal reportGates Learjet 25D · Pecos, NMWas physical impairment of the pilot in command from alcohol and drugs. A factor was the first officer's lack of experience in the lear jet.NTSB NYC85LA056Accident · No injuriesLimited investigationFinal reportGates Learjet 25D · Johnstown, PAThe acft overran the end of rwy 33 during an aborted takeoff. During the takeoff ground run the acft inadvertently became airborne at an airspeed bwt 80-150 KTS and ascended to an alt of aprx 30 ft AGL. The plt corrected for left yaw which was present and…NTSB DEN84LA046Accident · Serious injuriesLimited investigationFinal reportGates Learjet 25D · Eagle, COWhile en route, the aricrew encountered stronger headwinds than expected. They realized there would not be enough fuel reserved for an IFR flt to aspen, so the elected to divert to Eagle, CO. However, their landing at engle was delayed due to a snowplow (with…NTSB DCA80AA018Accident · 2 fatalClosedLearjet 25D · Gulf Of Mexico (Gulf of Mexico)NTSB DCA79AA007Accident · 6 fatalClosedLear Jet 25D · Detroit, MI