Fatal NTSB investigations: Gates Lear Jet 25B
8 cases on aircraft the registry lists as Gates Lear Jet 25B. 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
| 1974 | 1 |
|---|---|
| 1977 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 1992 | 1 |
| 1998 | 1 |
| 2001 | 1 |
| 2003 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5170511'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5170511'))
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 FTW03FA229Accident · 1 fatalField investigationFinal reportLearjet 25B · Del Rio, TXThe pilot's misjudged distance and speed during the approach to landing, and his failure to obtain the proper touchdown point resulting in an overrun. A contributing factor was the pilot's failure to abort the landing.NTSB IAD02FA018Accident · 2 fatalField investigationFinal reportGates Learjet 25B · Pittsburgh, PAThe (undetermined) pilot-at-the-controls' early, and over rotation of the airplane's nose during the takeoff attempt, and his failure to maintain directional control. Also causal, was the captain's inadequate remedial action, both during the takeoff attempt…NTSB FTW98MA096Accident · 2 fatalMajor investigationFinal reportGates Learjet 25B · Houston, TXThe flight crew's continued descent of the airplane below the glideslope and through the published decision height without visual contact with the runway environment. Also, when the captain encountered difficulty tracking the localizer course, his improper…NTSB CHI92FA170Accident · 2 fatalField investigationFinal reportGates Learjet 25B · Sheboygan Falls, WIThe copilot's premature liftoff and the captain's inadequate remedial action resulting in loss of aircraft control at low altitude.NTSB FTW80AA064Accident · 2 fatalClosedLear Jet 25B · Conlon, TXNTSB DEN79FA048Accident · 2 fatalClosedLear Jet 25B · Pueblo, CONTSB IAD77AA065Accident · 5 fatalClosedLearjet 25B · Sanford, NCNTSB DEN75AD007Accident · 4 fatalClosedGates Lear 25B · Briggsdale, CO