NTSB investigations · 13

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 ('1152014') 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 ('1152014')
  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 ('1152014')
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 GAA17CA138Accident · No injuriesData collectionFinal reportBeech T 34B · St. Petersburg, FLThe pilot's failure to maintain an appropriate glidepath to the runway.Feb 11, 2017 · N18PS · Substantial damage NTSB ATL98FA076Accident · Serious injuriesField investigationFinal reportBeech BE-45-T-34B · Montgomery, ALThe installation of an incorrect engine nose seal that subsequently dislodged from the normally installed position, and resulted in the loss of engine power. A factor was the loss of engine oil.May 14, 1998 · N9280Z · Destroyed NTSB CHI97FA300Accident · 2 fatalField investigationFinal reportBeech T34B · Fremont, MIThe pilot's failure to maintain adequate airspeed which resulted in a stall. Also causal was the pilot's ostentatious display.Sep 25, 1997 · N777SU · Destroyed NTSB NYC95LA074Accident · Serious injuriesLimited investigationFinal reportBeech T-34B · Jackson, NJthe flight instructor's attempt to maintain visual reference with the ground, and his delayed remedial action to the dual student's actions, which resulted in an inadvertent tree strike. Factors were the lack of recent night experience for both pilots, the…Mar 17, 1995 · N1440L · Destroyed NTSB ATL86FA160Accident · Serious injuriesField investigationFinal reportBeech D45(T34B) · Rome, GAJust before takeoff, a rain shower was observed approaching the arpt. The plt elected to make a maximum performance takeoff. Rprtdly, after lift-off. She initiated a climb at 70 KTS & raised the flaps. The plt reported beginning a shallow turn at aprx 200 ft…Jun 8, 1986 · N544E · Destroyed NTSB CHI81FA061Accident · 1 fatalClosedBeech T-34B · New Castle, INMay 31, 1981 · N74195 · Destroyed NTSB FTW80FA124Accident · 2 fatalClosedBeech T-34B · Giddings, TXSep 27, 1980 · N46939 · Destroyed NTSB ATL80FKG02Accident · No injuriesClosedBeech D45 · Stone Mountain, GAMay 26, 1980 · N4900S · Substantial damage NTSB IAD78DID08Accident · No injuriesClosedBeech T-34B · Dillwyn, VAJun 8, 1978 · N31810 · Substantial damage NTSB MIA76FKG05Accident · No injuriesClosedBeech T-34 · Marietta, GAJul 15, 1975 · N4900S · Substantial damage NTSB NYC74AN045Accident · 2 fatalClosedBeech T-34B · Kinston, NCNov 19, 1973 · N14514 · 2 aircraft · Destroyed NTSB NYC70D0102Accident · No injuriesClosedBeech T-34B · Orleans, MAAug 9, 1969 · N11SG · Substantial damage NTSB UNK64X2196Accident · No injuriesClosedBeechraft T34B · Santa Ana, CAJun 9, 1964 · N68629 · Destroyed

Back to Beech T-34B