Fatal NTSB investigations: Learjet 23
9 cases on aircraft the registry lists as Learjet 23. 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
| 1966 | 1 |
|---|---|
| 1969 | 1 |
| 1970 | 1 |
| 1972 | 1 |
| 1977 | 1 |
| 1980 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1991 | 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 ('5170102'))
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 ('5170102'))
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 CHI91MA224Accident · 3 fatalMajor investigationFinal reportLearjet 23 · Detroit, MIImproper preflight by the pilot, his failure to abort the takeoff while there was sufficient runway remaining, and his failure to assure that the aircraft attained sufficient airspeed for lift-off and climb. Factors related to the accident were: the pilot's…NTSB ATL90MA051Accident · 2 fatalMajor investigationFinal reportLearjet 23 · Ansonia, OHThe flight crew became incapacitated for undetermined reasons and lost control of the airplane.NTSB LAX88FA274Accident · 2 fatalField investigationFinal reportLearjet 23 · Perris, CAThe pilot decided to conduct his flight with known aircraft deficiencies. Induced company pressure to deliver the aircraft to its destination is considered to have been a factor in the accident.NTSB DCA80AA017Accident · 2 fatalClosedLear Jet 23 · Richmond, VANTSB CHI77FA022Accident · 2 fatalClosedLear Jet 23 · Flint, MINTSB CHI73AC058Accident · 2 fatalClosedLear 23 · Romulus, MINTSB DCA70AZ008Accident · 6 fatalClosedLear Jet 23A · Pellston, MINTSB CHI70A0027Accident · 7 fatalClosedLear Jet 23A · Racine, WINTSB FTW66A0095Accident · 2 fatalClosedLear Jet 23 · Clarendon, TX