Skip to content

NTSB investigations · 21

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 ('1152008') 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 ('1152008')
  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 ('1152008')
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 GAA18CA413Accident · No injuriesData collectionFinal reportBeech T34 · Dallas, TXThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during the landing flare, which resulted in an aerodynamic stall.Jul 9, 2018 · N6849C · Substantial damage NTSB NYC07LA144Accident · No injuriesLimited investigationFinal reportBeech T-34A · Maxton, NCA total loss of engine power for undetermined reasons.Jun 18, 2007 · N55192 · Substantial damage NTSB NYC84FA058Accident · 2 fatalField investigationFinal reportBeech T-34A · Stockton, NJPrior to the accident, the acft was observed in aerobatic type maneuvers. According to one witness, he saw the acft enter a descent after it had completed a roll maneuver. It was still in a steep descent when he lost sight of the acft due to trees. The acft…Dec 17, 1983 · N12EG · Destroyed NTSB MIA75AM058Accident · 2 fatalClosedBeech T-34A · Eustis, FLFeb 16, 1975 · N7724B · Destroyed NTSB OAK74FVM25Accident · Minor injuriesClosedBeech T-34A · Prunedale, CAApr 28, 1974 · N12268 · Destroyed NTSB MKC74AK030Accident · 1 fatalClosedBeech A45 · Cabool, MODec 12, 1973 · N12271 · Destroyed NTSB OAK72DVA22Accident · No injuriesClosedBeech A45 · Helm, CASep 17, 1971 · N12268 · Substantial damage NTSB FTW70DRG17Accident · Minor injuriesClosedBeech T-34A · Austin, TXMar 8, 1970 · N74025 · Substantial damage NTSB CHI69F0546Accident · No injuriesClosedBeech T-34A · Lima, OHMar 23, 1969 · N7724B · Substantial damage NTSB DEN69D0102Accident · Minor injuriesClosedBeech T-34A · Springervlle, AZSep 19, 1968 · N109L · Destroyed NTSB LAX68F0251Accident · Serious injuriesClosedBeech A45 · Corona, CADec 17, 1967 · N6978C · Destroyed NTSB ANC68F0070Accident · Serious injuriesClosedBeech A45 · Juneau, AKAug 31, 1967 · N9181Z · Destroyed NTSB MIA66F0567Accident · No injuriesClosedBeech A45 · Ocean Sprngs, MSMay 26, 1966 · N8239E · Substantial damage NTSB DEN66D0294Accident · No injuriesClosedBeech T-34A · Provo, UTApr 30, 1966 · N12271 · Substantial damage NTSB FTW66A0054Accident · 2 fatalClosedBeech T34A · Gila Bend, AZNov 30, 1965 · N12273 · Destroyed NTSB DEN65A0083Accident · 2 fatalClosedBeechcraft T-34 · Albuquerque, NMJun 19, 1965 · N12269 · Destroyed NTSB OAK65D0030Accident · No injuriesClosedBeechcraft T-34A · Merced, CAApr 4, 1965 · N7782C · Destroyed NTSB UNK65X0884Accident · No injuriesClosedBeechcraft T34 · Buckeye, AZNov 29, 1964 · N109L · Substantial damage NTSB UNK64X2678Accident · No injuriesClosedBeechcraft A45 · El Monte, CAJul 6, 1964 · N7898C · Substantial damage NTSB UNK64X1657Accident · Minor injuriesClosedBeechcraft T34 · Battle Creek, MIMay 7, 1964 · N3138C · Destroyed NTSB UNK64X0500Accident · No injuriesClosedBeechcraft T34 · Davis, CAFeb 8, 1964 · N5440V · Substantial damage

Back to Beech T-34A