NTSB investigations: Cessna 401A
5 cases on aircraft the registry lists as Cessna 401A, where the first occurrence was “Main gear collapsed”. 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
| 1983 | 3 |
|---|---|
| 1984 | 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 ('207590D')
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\" = 191))
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 ('207590D')
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" = 191))
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 MKC85LA016Accident · No injuriesLimited investigationFinal reportCessna 401A · Springfield, MOAfter a gear collapse following a manual extension of landing gear due to an electrical failure the acft was afforded a temporary repair by clamping a wrench to the landing gear strut to 'stiff-leg' it. The gear collapsed again during taxi to the active…NTSB NYC84FA089Accident · No injuriesField investigationFinal reportCessna 401A · Linden, NJThe main landing gear collapsed after landing. A CFI awaiting takeoff said that the approach and touchdown were normal with the gear down. As the acft rolled the left main gear collapsed and the acft gradually left the rwy and became miredin mud. Inspection…NTSB CHI83IA446Incident · No injuriesIncident investigationFinal reportCessna 401A · Frankfort, ILThe right main landing gear collapsed during landing roll-the right main landing gear bellcrank was found to have failed in instantaneous overload. The rigging of main gear was improper.NTSB ATL83LA373Accident · No injuriesLimited investigationFinal reportCessna 401A · Monroe, NCThe left landing gear collapsed on the acft as it was being taxied into the ramp. After turning left into the hub area the landing gear horn sounded and the left gear collapsed, according to the plt. A flt instructor who witnessed the accident said the ACFT'3…NTSB LAX83LA261Accident · No injuriesLimited investigationFinal reportCessna 401A · North Las Vegas, NVThe acfts main landing gear collapsed during landing touchdown. After the right main gear collapsed the acft veered to the right and came to rest about 600 ft beyond the threshold and 90 ft northwest of the rwy edge. An FAA inspector said 'it appears that an…