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 ('1380102') 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 ('1380102')
  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 ('1380102')
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 WPR24FA298Accident · 1 fatalClass 3 · FieldFinal reportBoeing A75L3 · Yacolt, WAThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at a low altitude in mountainous terrain in moderately high density altitude conditions, resulting in an aerodynamic stall and subsequent impact with terrain.Sep 6, 2024 · N53466 · Substantial damage NTSB CEN13LA068Accident · Minor injuriesLimited investigationFinal reportBoeing A75L3 · San Antonio, TXA partial loss of engine power during takeoff, likely due to the accumulation of carburetor ice.Nov 20, 2012 · N56226 · Substantial damage NTSB ATL03LA079Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75L3 · Gainesville, GAThe pilot's failure to maintain directional control during the landing roll resulting in an inadvertent ground loop.Apr 14, 2003 · N4908N · Substantial damage NTSB FTW99LA198Accident · Minor injuriesLimited investigationFinal reportBoeing A75L3 · Fort Worth, TXThe loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.Jul 23, 1999 · N59646 · Substantial damage NTSB LAX93LA158Accident · Serious injuriesLimited investigationFinal reportBoeing A75L3 · Carlsbad, CAThe pilot's inadequate preflight preparation in that he failed to refuel the aircraft prior to departure.Mar 22, 1993 · N58969 · Substantial damage NTSB NYC90LA143Accident · 1 fatalLimited investigationFinal reportBoeing A75L3 · Groton, CTAn impact with the ground following an improperly executed roll with insufficient altitude for recovery. Factors related to the accident were improper use of the flight controls by the pilot.Jun 30, 1990 · N1205V · Substantial damage NTSB DEN87LA086Accident · No injuriesLimited investigationFinal reportBoeing A75L3 · Belgrade, MTThe plt report that he was landing on a 9000 x 150 ft asphalt rwy. The wind was nearly down the rwy at 4 to 9 KTS. In a telephone interview 2 days after the accident the plt reported that he was making a 'wheels' landing. He said when the main gear was about…Apr 5, 1987 · N5084N · Substantial damage NTSB LAX80DVD36Accident · No injuriesClosedBoeing A75L3 · Stockton, CAAug 12, 1980 · N56323 · Substantial damage NTSB OAK79FVD12Accident · Serious injuriesClosedBoeing A-75 · Manteca, CAFeb 27, 1979 · N68250 · Destroyed NTSB OAK78FVD30Accident · Serious injuriesClosedBoeing A75N1 · Tracy, CAApr 26, 1978 · N68250 · Destroyed NTSB OAK76DVA13Accident · No injuriesClosedBoeing A75 · Los Banos, CASep 27, 1975 · N54671 · 2 aircraft · Substantial damage NTSB OAK75 VA75Accident · No injuriesClosedBoeing A75L3 · Hickman, CAJun 26, 1975 · N56905 · Substantial damage NTSB OAK75DVD33Accident · No injuriesClosedBoeing A75N1 · Santa Rosa, CAJan 14, 1975 · N62945 · Substantial damage NTSB FTW73FRA29Accident · No injuriesClosedBoeing E75 · Nome, TXMay 9, 1973 · N1682M · Substantial damage NTSB OAK69F0069Accident · 1 fatalClosedBoeing A75L-3 · Knights Lndg, CAJul 19, 1968 · N56226 · Destroyed NTSB OAK68D0227Accident · Minor injuriesClosedStearman A75 · Hlf Moon By, CADec 2, 1967 · N62758 · Substantial damage NTSB OAK68D0165Accident · No injuriesClosedBoeing A75N1 · Dos Palos, CAJul 20, 1967 · N54671 · Destroyed NTSB FTW67F0567Accident · No injuriesClosedBoeing E75 · Nome, TXApr 24, 1967 · N1682M · 2 aircraft · Substantial damage NTSB NYC67F0126Accident · No injuriesClosedBoeing D75 · Colts Neck, NJJul 23, 1966 · N59269 · Substantial damage NTSB FTW66F0273Accident · No injuriesClosedBoeing A75N1 · Dumas, ARAug 28, 1965 · N59879 · Substantial damage NTSB UNK65X1116Accident · No injuriesClosedBoeing A75L3 · Immokalee, FLDec 24, 1964 · N5735N · Destroyed NTSB UNK65X0879Accident · No injuriesClosedBoeing A-75 · Homestead, FLNov 29, 1964 · N50164 · 2 aircraft · Substantial damage NTSB UNK65X0879Accident · No injuriesClosedBoeing A-75 · Homestead, FLNov 29, 1964 · N50744 · 2 aircraft · Substantial damage NTSB UNK64X2480Accident · No injuriesClosedBoeing A75L3 · Keo, ARJun 25, 1964 · N62182 · Substantial damage NTSB UNK64X0888Accident · Minor injuriesClosedBoeing D75 · Kilgore, TXMar 11, 1964 · N17674 · Substantial damage

Back to Boeing A75L3