NTSB investigations: Swearingen SA227-AC, 1982
3 cases on aircraft the registry lists as Swearingen SA227-AC. 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.
Cases per year
| 1982 | 3 |
|---|---|
| 1987 | 1 |
| 1988 | 2 |
| 1989 | 1 |
| 1992 | 2 |
| 1994 | 1 |
| 1997 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2005 | 1 |
| 2010 | 1 |
| 2012 | 1 |
Where
Open the mapLatest cases
Query with SQL
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 year(c.\"eventDate\") = 1982
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8780603'))
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 year(c."eventDate") = 1982
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8780603'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 DEN83LA036Accident · No injuriesLimited investigationFinal reportSwearingen SA-227AC · Gillette, WYDirectional control was lost in the early stage of the takeoff roll. The acft departed the rwy 400 ft down the rwy & travelled 85 ft off the side of the rwy. One rwy light was destroyed. The acft had come from the factory equipped with an anti-skid brake…NTSB DEN83AA032Accident · 2 fatalFinal reportSwearingen SA-227AC · Pueblo, COAt 1906 the flt was cleared to descend & maintain 7,500 ft, turn right to a heading 040 for an asr apch to Pueblo memorial arpt, & that the mda is 5,200. The flt read back "left to one forty five two zero zero." Approach control advised the flt that the…NTSB CHI83LA021Accident · No injuriesLimited investigationFinal reportSwearingen SA227-AC · Indianapolis, INThe left wing struck a building during taxi into the passenger gate. Ground personnel were stationed on each side of the aircraft.