NTSB investigations: Aviat A-1B
12 cases on aircraft the registry lists as Aviat A-1B, where the first occurrence was “Loss of control - on ground/water”. 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
| 2000 | 1 |
|---|---|
| 2001 | 2 |
| 2003 | 3 |
| 2004 | 1 |
| 2006 | 3 |
| 2007 | 2 |
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 ('2210406')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
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 ('2210406')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
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 SEA07CA261Accident · No injuriesData collectionFinal reportAviat A-1B · Grangeville, IDThe pilot's failure to maintain directional control during the landing roll. Factors include a ditch located between the runway and the taxiway.NTSB DEN07CA080Accident · No injuriesData collectionFinal reportAviat A-1B · Englwood, COThe pilot's failure to maintain directional control during landing resulting in a ground loop.NTSB CHI07CA030Accident · No injuriesData collectionFinal reportAviat A-1B · St Louis, MOThe pilot's failure to maintain directional control during landing which resulted in the wing striking the ground during the inadvertent ground loop.NTSB LAX06CA144Accident · No injuriesData collectionFinal reportAviat A-1B · Chandler, AZThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during the landing rollout. A contributing factor was the pilot's excessive use of the flight controls.NTSB SEA06CA070Accident · No injuriesData collectionFinal reportAviat A-1B · Driggs, IDThe pilot's failure to maintain directional control during the landing roll, which resulted in a loss of control and subsequent nose over. Contributing factors were the tailwind and the soft snow-covered terrain.NTSB ATL04CA168Accident · No injuriesData collectionFinal reportChristen Industries A1B · Hickory, NCThe pilot’s inadequate compensation for wind conditions and his failure to maintain directional control, during landing roll which resulted in a loss of control and collision with a trailer. The crosswind was a factor in the accident.NTSB SEA04LA028Accident · No injuriesLimited investigationFinal reportAviat A-1B · Hailey, IDThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent group loop and the collapse of the right main landing gear.NTSB SEA03LA167Accident · No injuriesLimited investigationFinal reportAviat A-1B · Driggs, IDThe pilot's failure to maintain control of the aircraft during the landing roll. A contributing factor was the dust devil.NTSB DEN03LA058Accident · No injuriesLimited investigationFinal reportAviat A-1B · Englewood, COthe pilot's failure to maintain directional control of the airplane, resulting in an inadvertent ground loop. A contributing factor was the gusty winds.NTSB LAX01LA170Accident · No injuriesLimited investigationFinal reportAviat A-1B · Apex, NVThe pilot's failure to maintain directional control during landing rollout in a gusty and crosswind condition.NTSB FTW01LA089Accident · No injuriesLimited investigationFinal reportAviat A-1B Husky · Odessa, TXthe pilot's failure to maintain directional control during landing, which resulted in a ground loop.NTSB NYC00LA238Accident · No injuriesLimited investigationFinal reportAviat A-1B · Newberryport, MAthe failure of the pilot to maintain directional control during landing and a subsequent rejected landing. Factors were the crosswind, and the delayed corrective action by the pilot.