Skip to content

NTSB investigations · 31

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 ('2071302') 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 ('2071302')
  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 ('2071302')
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 ERA13FA402Accident · 2 fatalField investigationFinal reportCessna T-50 · Lenox Twp., PAThe pilot's intentional visual flight into night instrument meteorological conditions and thunderstorms and his improper decision to takeoff without getting updated weather information after a briefer cautioned him during a previous flight that visual flight…Sep 3, 2013 · N41759 · Destroyed NTSB NYC04LA118Accident · 1 fatalLimited investigationFinal reportCessna T-50 · Sharon, MAThe loss of power in one engine for undetermined reasons. Factors were the excessive weight, and degraded climb performance.May 7, 2004 · N45P · Substantial damage NTSB SEA98LA193Accident · No injuriesLimited investigationFinal reportCessna T-50 · Missoula, MTA quick drain was open due to the pilot's inadequate preflight.Sep 27, 1998 · N6HS · Substantial damage NTSB FTW90LA078Accident · Minor injuriesLimited investigationFinal reportCessna T50-A17 · Brackettville, TXAn engine failure caused by a malfunctioning carburetor and the pilot's misjudging his obstacle clearance which resulted in a wire strike while maneuvering to land. Factors in the accident were the uncommanded deployment of carburetor heat on both engines, an…Mar 4, 1990 · N578EK · Substantial damage NTSB DEN81FTA11Accident · Serious injuriesClosedCessna T-50 · Ft Smith, MTJul 12, 1981 · N68006 · Destroyed NTSB OAK76DVD03Accident · No injuriesClosedCessna T-50 · Sonoma, CAAug 10, 1975 · N66794 · Substantial damage NTSB MKC73DCJ32Accident · No injuriesClosedCessna T-50 · Omaha, NEMar 27, 1973 · N54302 · 2 aircraft · Minor damage NTSB NYC71DFA15Accident · Minor injuriesClosedCessna T-50 · Oriskany, NYSep 9, 1970 · N48481 · Substantial damage NTSB LAX71FUA16Accident · No injuriesClosedCessna T-50 · Capstrano B, CASep 9, 1970 · N58599 · Substantial damage NTSB FTW71FPD01Accident · No injuriesClosedCessna T-50 · Coleman, TXJul 3, 1970 · N49486 · Destroyed NTSB CHI70FBJ01Accident · No injuriesClosedCessna UC-78B · South Haven, MIJan 8, 1970 · N63878 · Destroyed NTSB SEA70D0087Accident · No injuriesClosedCessna T-50 · Everett, WASep 14, 1969 · N1261N · Substantial damage NTSB CHI70F0257Accident · No injuriesClosedCessna T-50 · Buffalo, ILJul 4, 1969 · N64056 · Substantial damage NTSB ANC69D0032Accident · Minor injuriesClosedCessna T-50 · Stevens Vill, AKSep 1, 1968 · N64700 · Destroyed NTSB SEA69A0009Accident · 3 fatalClosedCessna T-50 · Ellensburg, WAJul 27, 1968 · N50615 · Destroyed NTSB FTW67F0170Accident · Serious injuriesClosedCessna T50 · Pocahontas, ARAug 6, 1966 · N5584N · Destroyed NTSB CHI66D0669Accident · No injuriesClosedCessna T-50 · E St Louis, ILApr 13, 1966 · N30L · Substantial damage NTSB OAK66D0212Accident · No injuriesClosedCessna T-50 · Kalaupapa, HIMar 12, 1966 · N62018 · Substantial damage NTSB NYC66F0375Accident · No injuriesClosedCessna T-50 · Jewett City, CTNov 25, 1965 · N58309 · Substantial damage NTSB DEN65F0114Accident · Serious injuriesClosedCessna T-50 · Santa Rosa, NMApr 4, 1965 · N5050N · Destroyed NTSB NYC65F0105Accident · No injuriesClosedCessna T-50 · Manville, NJApr 3, 1965 · N60978 · Destroyed NTSB UNK65X0353Accident · No injuriesClosedCessna T-50 · Collegeville, PAOct 21, 1964 · N69841 · Substantial damage NTSB UNK65X0145Accident · No injuriesClosedCessna T50 · Elsimore, CAOct 4, 1964 · N62448 · Substantial damage NTSB UNK64X4026Accident · No injuriesClosedCessna T50 · Curice, OHSep 17, 1964 · N54625 · Substantial damage NTSB UNK64X3372Accident · 2 fatalClosedCessna T-50 · New Florence, PAAug 13, 1964 · N61812 · Destroyed NTSB UNK64X3284Accident · 2 fatalClosedCessna T-50 · Rio Vista, CAAug 8, 1964 · N63560 · Destroyed NTSB UNK64X2573Accident · No injuriesClosedCessna T50 · Lost River, AKJun 29, 1964 · N30023 · Substantial damage NTSB UNK64X1124Accident · No injuriesClosedCessna T50 · Omaha, NEApr 1, 1964 · N67281 · Substantial damage NTSB UNK64X0858Accident · No injuriesClosedCessna T50 · Visalia, CAMar 9, 1964 · N5062N · Substantial damage NTSB UNK64X0421Accident · No injuriesClosedCessna T50 · Gloster, MSFeb 1, 1964 · N55028 · Substantial damage NTSB ANC63A0060Accident · No injuriesClosedCessna T-50 · Bethel, AKJan 17, 1963 · N67643 · Substantial damage

Back to Cessna T-50