NTSB investigations: Swearingen SA226TC

59 cases on aircraft the registry lists as Swearingen SA226TC. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases, 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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8780404')) 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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
  WHERE c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8780404'))
  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_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8780404'))
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 LAX82DUG12Accident · Serious injuriesFinal reportSwearingen SA226-TC · Palm Springs, CAAfter starting the engines at night, a signal was given to a line service employee to disconnect the APU. While attempting to disconnect the APU, the line service employee moved into the path of the right propeller and was seriously injured.May 29, 1982 · N1009R · Minor damage NTSB CHI82IA108Incident · No injuriesIncident investigationFinal reportSwearingen SA226TC · Chicago, ILThe aircraft veered left at slow speed but the veer was corrected. At 60 KTS the aircraft veered again and was not corrected. Aircraft left runway and damaged props. Service bulletin SA-226 no. 103 dated 01/20/82 states that limits be placed on use of nose…Mar 31, 1982 · N62Z · Minor damage NTSB CHI822A073Incident · No injuriesClosedSwearingen SA-226 · Detroit, MIJul 7, 1981 · N781S · Minor damage NTSB CHI81IA025CaseClosedSwearingen SA226 · Indianapolis, INFeb 13, 1981 · N325BA NTSB DCA80AA019Accident · 13 fatalClosedSwearingen 226TC · Valley, NEJun 12, 1980 · N650S · Destroyed NTSB CHI79IA005Incident · No injuriesClosedSwearingen SA226 · Lafayette, INOct 6, 1978 · N781S · Minor damage NTSB FTW78FA068Accident · Serious injuriesClosedSwearingen SA226 · Austin, TXAug 13, 1978 · N300TL · Destroyed NTSB MIA78FA079Incident · No injuriesClosedSwearingen 226-TC · Muscle Shoals, ALMay 8, 1978 · N70A · Minor damage NTSB MKC77DA012Accident · Serious injuriesClosedSwearingen SA-226 · Parsons, KSFeb 2, 1977 · N224AM · No damage