Skip to content

NTSB investigations · 15

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 ('2075721') 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 ('2075721')
  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 ('2075721')
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 ERA18LA176Accident · No injuriesLimited investigationFinal reportCessna 337 · Atlanta, GAAn area of pitting and corrosion on the surface of the aluminum hydraulic line connecting the emergency handle/pump to the electric hydraulic pump, which resulted in a loss of hydraulic pressure and the pilot’s inability to extend the landing gear.May 29, 2018 · N86507 · Substantial damage NTSB MIA98LA090Accident · Serious injuriesLimited investigationFinal reportCessna 337 · Raymond, MSthe pilot passenger's impairment of judgment and performance due to alcohol, and control interference by the pilot passenger, which resulted in a loss of aircraft control and subsequent in-flight collision with the runway and trees.Feb 28, 1998 · N1287M · Destroyed NTSB LAX89LA049Accident · No injuriesLimited investigationFinal reportCessna 337E · Kahului, HIThe plt rprtd that after about 10 hrs on an overwater ferry flt, he noticed high oil temp & low oil pressure indcns fromthe rear eng. Eventually the rear eng began running rough, so he shut it down, feathered its prop and 'increased power on the front…Nov 13, 1988 · N1259M · Destroyed NTSB NYC88FA072Accident · 1 fatalField investigationFinal reportCessna 337E · Friedens, PAThe 24 year old unlicensed pilot made an unauthorized flight in his father's aircraft. The Cessna 337 was observed to manuever in the vicinity of the airport at a low altitude in and out of the clouds. The aircraft was then observed to come out of the clouds…Feb 2, 1988 · N1201M · Destroyed NTSB MIA87LA158Accident · Serious injuriesLimited investigationFinal reportCessna 337E · San Juan, PRThe plt stated that during the base leg with 2/3 flaps lowered the acft entered an uncontrolled left bank. Control was partially regained, however, the acft then entered a spin to the left. Control was not established before the acft crashed into the ocean…May 8, 1987 · N1253M · Substantial damage NTSB MIA87LA100Accident · No injuriesLimited investigationFinal reportCessna 337E · New Smyrna Bch, FLThe plt stated that on short final the auto-plt activated resulting in an uncontrolled 50-60 degree nose low left bank. The acft then veered from the apch path off the arpt property where it then collided with a vehicle & tree before coming to rest.…Mar 8, 1987 · N100LT · Substantial damage NTSB ATL84LA128Accident · Minor injuriesLimited investigationFinal reportCessna 337E · Tifton, GAThe acft reportedly was not tied down. The plt was hand propping the aft engine while the forward engine was running. In an attempt to board the acft the pilot was run over by the right main gear. The acft continued to travel until it collided with trees.Mar 26, 1984 · N86520 · Substantial damage NTSB MIA81FKA01Accident · Serious injuriesClosedCessna 337 · Aguadilla, PROct 10, 1980 · N1308M · Destroyed NTSB MIA79FA016Accident · 2 fatalClosedCessna 337E · Daytona Beach, FLNov 21, 1978 · N86540 · Destroyed NTSB MIA76DKT31Accident · No injuriesClosedCessna 337 · Miami, FLNov 27, 1975 · N1259M · Substantial damage NTSB MIA74DKT77Accident · No injuriesClosedCessna 190 · Miami, FLMay 4, 1974 · N68T · Substantial damage NTSB LAX72DUG45Accident · No injuriesClosedCessna 337 · Palm Sprngs, CAJan 1, 1972 · N1275M · Substantial damage NTSB FTW71DQG70Accident · No injuriesClosedCessna 337 · Plainview, TXMay 11, 1971 · N1277M · Substantial damage NTSB LAX71FUG60Accident · No injuriesClosedCessna 337 · Chino, CAMar 20, 1971 · N123PH · Substantial damage NTSB MKC71DCQ33Accident · No injuriesClosedCessna 150J · Protection, KSMar 2, 1971 · N61000 · Substantial damage

Back to Cessna 337E