NTSB investigations: Cessna 402B
12 cases on aircraft the registry lists as Cessna 402B, where the first occurrence was “Airframe/component/system failure/malfunction”. 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 | 2 |
|---|---|
| 1984 | 2 |
| 1987 | 2 |
| 1988 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1995 | 1 |
| 2001 | 1 |
| 2003 | 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 ('207590P')
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\" = 130))
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 ('207590P')
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" = 130))
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 MIA03IA110Incident · No injuriesIncident investigationFinal reportCessna 402C · Miami, FLThe inadequate annual inspection of the airplane by other maintenance personnel for failure to note an incorrect washer was installed securing the upper and lower torque links, resulting in separation of the upper and lower links and subsequent rotation of…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 SEA95LA159Accident · No injuriesLimited investigationFinal reportCessna 402B · Wenatchee, WAImproper installation (failure to install cotter key) by company maintenance personnel.NTSB ATL92LA133Accident · No injuriesLimited investigationFinal reportCessna 402B · Tuscaloosa, ALThe improper installation of the emergency exit, by an unknown person, which resulted in its separation, in flight.NTSB DEN90LA071Accident · No injuriesLimited investigationFinal reportCessna 402B · Alamogordo, NMThe collapse of the right main landing gear as a result of the malfunction of the down lock assembly and failure of the torque tube bracket assembly.NTSB ATL88FA186Accident · 1 fatalField investigationFinal reportCessna 402B · West Columbia, SCThe airplane used about 1/2 of the 8,602 ft rwy for the t/o roll. After t/o it pitched nose-down briefly over the rwy during init climb. The plt radioed that he was having a problem with the elevator which required 'full back pressure' to keep the nose up,…NTSB MIA87IA229Incident · No injuriesIncident investigationFinal reportCessna 402B · W.Palm Beach, FLThe lt main gear would not extend when the plt attempted to lower the gear & and the acft was landed in that condition. An exam of the strut assy revealed that a bearing, p/n 5041108-1/2 had failed permitting the strut to overextend, jamming the gear in the…NTSB CHI87FA176Accident · 1 fatalField investigationFinal reportCessna 402B · Chicago, ILFailure of maintenance personnel to perform proper installation of the left throttle linkage.NTSB MIA85IA069Incident · No injuriesIncident investigationFinal reportCessna 402B · Sanford, FLDuring cruise flt, the acft suddenly nosed down & began vibrating. Remedial action was taken & an uneventful emerg landing was made. An exam revealed that the bolt, nut & cotter pin (used to attach the elevator trim control rod to the elevator trim tab) were…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 MIA83LA122Accident · No injuriesLimited investigationFinal reportCessna 402B · Ft. Pierce, FLThe acft was landed wheels up. The pilot stated that he never heard the landing gear warning horn operate. Post accidentinvestigation showed that the landing gear operated properly but that the warning horn was inoperative. The pilot of theaccident acft held…NTSB MKC83IA054Incident · No injuriesIncident investigationFinal reportCessna 402B · St. Louis, MOThe right engine of the acft started to burn while the acft was being started. The pilot noticed flames coming out of the top of the right engine after the left engine was started. The pilot initiated shut down of both engines and evacuation of the…