Skip to content

NTSB investigations · 25

Matched to the registry by N-number and event date, newest first.

Query with SQL

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.aircraft_model_code IN ('5170102') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('5170102')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 LAX98LA105Accident · No injuriesLimited investigationFinal reportLearjet 23 · Oakdale, CAfailure of the flight crew to extend the landing gear before landing.Mar 4, 1998 · N37BL · Substantial damage NTSB CHI95LA013Accident · No injuriesLimited investigationFinal reportLearjet 23 · Holland, MIThe copilot's misjudgment of the touchdown point, and the pilot in command's inadequate supervision to avoid the accident.Oct 14, 1994 · N20TA · Substantial damage 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…Jul 23, 1991 · N959SC · Destroyed NTSB ATL91LA122Accident · No injuriesLimited investigationFinal reportLearjet 23 · Columbia, TNThe pilot's premature decision to turn off the anti-skid during landing roll. Factors to this accident were hydroplaning conditions.Jul 2, 1991 · N500FM · Substantial damage NTSB ATL90MA051Accident · 2 fatalMajor investigationFinal reportLearjet 23 · Ansonia, OHThe flight crew became incapacitated for undetermined reasons and lost control of the airplane.Jan 18, 1990 · N331DP · Destroyed 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.Jul 30, 1988 · N745F · Destroyed NTSB CHI85FA344Accident · No injuriesField investigationFinal reportLearjet 23 · Madison, WIThe plt elected to take off with a heavy loaded acft on the short rwy. The plt stated a loud noise was heard as the acft approached 80 KTS. The takeoff was aborted at 100 KTS. Hydroplaning was experienced and a loss of control occurred. The acft traveled off…Aug 13, 1985 · N61TS · Substantial damage NTSB DCA80AA017Accident · 2 fatalClosedLear Jet 23 · Richmond, VAMay 6, 1980 · N866JS · Destroyed NTSB LAX78FA040Accident · Minor injuriesClosedLear 23 · Burbank, CAMar 30, 1978 · N133W · Destroyed NTSB CHI77FA022Accident · 2 fatalClosedLear Jet 23 · Flint, MIJan 6, 1977 · N332PC · Destroyed NTSB LAX73FUM21Accident · No injuriesClosedLear Jet 23 · Carlsbad, CAMar 8, 1973 · N332PC · Substantial damage NTSB CHI73AC058Accident · 2 fatalClosedLear 23 · Romulus, MIDec 15, 1972 · N20M · Destroyed NTSB DCA70AZ008Accident · 6 fatalClosedLear Jet 23A · Pellston, MIMay 9, 1970 · N434EJ · Destroyed NTSB CHI70A0027Accident · 7 fatalClosedLear Jet 23A · Racine, WINov 6, 1969 · N1021B · Destroyed NTSB CHI68A0051Accident · Minor injuriesClosedLear Jet 23 · Detroit, MIDec 9, 1967 · N822LJ · Destroyed NTSB CHI68A0039Accident · Minor injuriesClosedLear Jet 23 · Muskegon, MIOct 25, 1967 · N432EJ · Destroyed NTSB DEN67A0066Accident · No injuriesClosedLear 23 · Spanish Fork, UTApr 23, 1967 · N434EJ · Substantial damage NTSB MIA67D0099Accident · No injuriesClosedLear Jet 23 · Manteo, NCJul 29, 1966 · N332PC · Substantial damage NTSB FTW66I0115Incident · No injuriesClosedLear Jet · Enid, OKJun 15, 1966 · N802L · 2 aircraft · Substantial damage NTSB FTW66I0115Incident · No injuriesClosedLear Jet 23 · Enid, OKJun 15, 1966 · N802L · 2 aircraft · Substantial damage NTSB FTW66A0095Accident · 2 fatalClosedLear Jet 23 · Clarendon, TXApr 23, 1966 · N235R · Destroyed NTSB FTW66D0611Accident · No injuriesClosedLear 23 · Marfa, TXApr 4, 1966 · N332PC · Substantial damage NTSB MKC65A0076Accident · No injuriesClosedLearjet 23 · Wichita, KSJun 14, 1965 · N802L · Substantial damage NTSB UNK64X2114Accident · No injuriesClosedLear M23 · Wichita, KSJun 4, 1964 · N801L · Destroyed NTSB UNK64X1054Accident · No injuriesClosedLear Jet 23 · Wichita, KSMar 27, 1964 · N802L · Substantial damage

Back to Learjet 23