Skip to content

NTSB investigations · 24

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 ('1380132') 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 ('1380132')
  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 ('1380132')
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 CEN26LA313Accident · Minor injuriesClass 3 · LimitedPreliminary reportStearman A75 · Bogue Chitto, MSOn September 8, 2026, about 1100 central daylight time, a Boeing-Stearman A75L300 airplane, N680HW, was substantially damaged when it was involved in an accident near Bogue Chitto, Mississippi. The pilot sustained minor injuries and the passenger was…Sep 8, 2026 · N680HW · Substantial damage NTSB CEN26LA305Accident · No injuriesClass 4 · LimitedInvestigation openBoeing A75L300 · Taylor, TXSep 1, 2026 · N175MD · Substantial damage NTSB CEN10LA340Accident · No injuriesLimited investigationFinal reportBoeing A75L300 · Salina, KSA partial loss of engine power after takeoff due to thermal damage to three cylinders for undetermined reasons. Contributing to the accident was a lack of suitable terrain for a forced landing.Jun 4, 2010 · N75263 · Substantial damage NTSB CEN09CA507Accident · Serious injuriesData collectionFinal reportBoeing A75L300 · Salina, KSThe pilot's failure to maintain directional control during a touch-and-go.Aug 10, 2009 · N75263 · Substantial damage NTSB ANC06LA058Accident · No injuriesLimited investigationFinal reportBoeing A75-L3 · Lake Wales, FLThe pilot's failure to maintain proper runway alignment during the takeoff roll, which resulted in a collision with trees during a precautionary landing when the airplane touched down to the right of the runway edge. A factor contributing to the accident was…May 21, 2006 · N60562 · Substantial damage NTSB IAD01LA079Accident · No injuriesLimited investigationFinal reportBoeing A75L300 · Matawan, NJThe inadequate maintenance inspection of the airplane by its owner, which resulted in a locked brake and a nose-over during the takeoff roll.Jul 15, 2001 · N2313 · Substantial damage NTSB NYC98LA065Accident · No injuriesLimited investigationFinal reportBoeing A75L300 · Chester, NYThe pilot's inadequate preflight which failed to reveal fuel contamination.Feb 7, 1998 · N55412 · Substantial damage NTSB NYC94LA141Accident · No injuriesLimited investigationFinal reportBoeing Stearman PT-13 · Readington, NJThe failure of both pilots to maintain adequate visual lookout.Jul 31, 1994 · N2313 · 2 aircraft · Minor damage NTSB NYC88LA164Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Marlboro, NJThe pilot was making a landing to the west when he experienced a loss of directional control and groundlooped on the right side of the runway. He said the tailwheel of the acft was already on the ground when the groundloop occurred and he lost control when a…Jun 11, 1988 · N2313 · Substantial damage NTSB MIA84LA158Accident · No injuriesLimited investigationFinal reportBoeing A75L300 · Daytona Beach, FLThe acft lost power while the plt was towing a banner over water. He was unable to restart the eng & subsequesntly ditched the acft in the ocean near Daytona Beach, FL. The plt elected to keep the banner attached to the acft to keep the plane from flipping…May 1, 1984 · N65676 · Substantial damage NTSB NYC81FNC20Accident · No injuriesClosedBoeing A75L · Fryeburg, MEAug 24, 1981 · N1153V · Substantial damage NTSB NYC78DNC34Accident · No injuriesClosedBoeing A75 · Jay, MEJun 25, 1978 · N1153V · Substantial damage NTSB LAX76DVA80Accident · No injuriesClosedBoeing IB75A · Shafter, CAJul 27, 1976 · N53406 · Substantial damage NTSB LAX75DVA32Accident · No injuriesClosedBoeing IB75A · Shafter, CAOct 18, 1974 · N53406 · Substantial damage NTSB NYC74FHA05Accident · No injuriesClosedBoeing A75N1 · Erwinna, PAAug 4, 1973 · N2313 · Substantial damage NTSB FTW73DRD23Accident · No injuriesClosedBoeing A75 · Lacassine, LAMay 8, 1973 · N75263 · Substantial damage NTSB NYC72FNA02Accident · No injuriesClosedBoeing A75 · Wareham, MAJul 7, 1972 · N1419M · Substantial damage NTSB FTW71DRD46Accident · No injuriesClosedBoeing A75 · Vinton, LAMay 15, 1971 · N75263 · Substantial damage NTSB FTW70F0141Accident · 1 fatalClosedBoeing B75N1 · Lake Charles, LAAug 18, 1969 · N75263 · Destroyed NTSB MIA70F0048Accident · Serious injuriesClosedBoeing A75N1 · West Point, MSJul 11, 1969 · N55377 · Substantial damage NTSB OAK68F0126Accident · Serious injuriesClosedBoeing A75 · Selma, CAAug 27, 1967 · N54896 · Destroyed NTSB MKC66F0129Accident · No injuriesClosedBoeing A75 · Grand Forks, NDAug 11, 1965 · N62598 · Substantial damage NTSB UNK64X2497Accident · No injuriesClosedBoeing A75 · Columbia, LAJun 26, 1964 · N69763 · Substantial damage NTSB UNK64X1683Accident · No injuriesClosedStearman A75N1 · Gueydan, LAMay 9, 1964 · N3939C · Destroyed

Back to Boeing A75L300