NTSB investigations: Cessna 402B, TX
8 cases on aircraft the registry lists as Cessna 402B. 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
| 1976 | 1 |
|---|---|
| 1981 | 2 |
| 1982 | 1 |
| 1984 | 1 |
| 1986 | 1 |
| 1991 | 1 |
| 2001 | 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.\"eventStateOrRegion\" = 'TX' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('207590P'))
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."eventStateOrRegion" = 'TX' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('207590P'))
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 FTW01FA104Accident · 1 fatalField investigationFinal reportCessna 402B · Del Rio, TXthe loss of control due to a jammed trim tab, which resulted from the failure of maintenance personnel to properly secure the trim tab actuator rod when installing a replacement elevator.NTSB FTW92FA029Accident · Serious injuriesField investigationFinal reportCessna 402B · Roanoke, TXThe operation of the airplane with known deficiencies, a missing air cooling baffle, and inadequate maintenance. Factors were the frozen propeller, inability of the pilot to feather the propeller, inoperative landing gear, the inability of the pilot to…NTSB FTW86FQG11Accident · No injuriesFinal reportCessna 402B · Plainview, TXThe acft landed gear up after a practice single-eng procedure. The plt attempted a go-around when the landing was aborted due to an improper approach. When the approach proceeded to this point with an intentionally inoperative eng the go-around was not a…NTSB FTW84LA184Accident · No injuriesLimited investigationFinal reportCessna 402B · El Paso, TXDuring gear extension in preparation for landing the nose gear failed to extend fully even though emergency gear extension proceedures were performed. The plt steered the acft off to the right of the rwy shortly after touchdown. Acftinspection revealed a…NTSB FTW82AA046Accident · 7 fatalFinal reportRobertson C-402B · Laredo, TXThe acft was observed to be extremely slow throughout the approach & that the plt appeared to be having some difficulty with over-controlling the acft. It then leveled out at 50-80 ft AGL on final over the threshold, entered a nose-high attitude & then…NTSB FTW81FRA43Accident · No injuriesClosedCessna 402B · Houston, TXNTSB FTW81FA028Accident · 2 fatalClosedCessna 402B · Laredo, TXNTSB FTW76AF077Accident · 2 fatalClosedCessna 402B · Giddings, TX