NTSB investigations: AS+ AC 4
7 cases on aircraft the registry lists as AS+ AC 4. 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
| 1996 | 1 |
|---|---|
| 1997 | 1 |
| 1998 | 1 |
| 2001 | 1 |
| 2005 | 2 |
| 2017 | 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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('05628R1'))
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 ('05628R1'))
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 CEN17LA181Accident · 1 fatalLimited investigationFinal reportAS+ AC 4 · Blair, NEThe pilot's loss of control due to his diverted attention as he attempted to close the canopy that opened during initial climb.NTSB LAX05LA239Accident · 1 fatalLimited investigationFinal reportAs+ AC4 · Sparks, NVthe pilot's failure to maintain an adequate airspeed while performing S-turns on final approach, which resulted in a stall and uncontrolled descent into terrain. A contributing factor in the accident was the pilot's impairment due to ingestion of an…NTSB SEA05LA114Accident · 1 fatalLimited investigationFinal reportAvia Stroitel AC-4B · Wenatchee, WAThe pilot's failure to maintain terrain clearance for undetermined reasons.NTSB CHI01LA332Accident · Serious injuriesLimited investigationFinal reportAviaStrottel AC 4C · Marshfield, MIThe pilot's decision to release from the tow plane during the takeoff. A factor associated with the accident was the pilot's vision was restricted by his hat during the takeoff.NTSB FTW98LA223Accident · Serious injuriesLimited investigationFinal reportAS+ AC-4 · Cedar Fort, UTFailure by the pilot to maintain control of the aircraft. A factor was lack of experience in make and model.NTSB FTW97LA349Accident · No injuriesLimited investigationFinal reportAS+ AC-4B · Sundance, WYimproper planning/decision by the pilot, which led to a snag and sudden slack in the tow rope, and necessitated an aborted launch (emergency landing) after initial liftoff. This in turn led to an inadvertent stall, a wing drop, and the left wing tip dragging…NTSB CHI96LA165Accident · Serious injuriesLimited investigationFinal reportAS+ AC 4 · Hartford, WIlack of airspeed control by the pilot, while maneuvering.