NTSB investigations: Cessna 402B, MO
6 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
| 1981 | 1 |
|---|---|
| 1982 | 1 |
| 1983 | 1 |
| 1997 | 1 |
| 2002 | 1 |
| 2020 | 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\" = 'MO' 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" = 'MO' 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 CEN20LA149Accident · No injuriesClass 3 · LimitedFinal reportCessna 402 · Kirksville, MOA loss of engine power after takeoff for undetermined reasons.NTSB CHI02LA210Accident · No injuriesLimited investigationFinal reportCessna 402B · St. Louis, MOThe landing gear collapsed for undetermined reasons.NTSB CHI97LA191Accident · No injuriesLimited investigationFinal reportCessna 402B · Springfield, MOThe pilot-in-command's (CFI) inadequate supervision and failure to take remedial action. A factor was the dual student's failure to maintain directional control.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…NTSB MKC82IA079Incident · No injuriesIncident investigationFinal reportCessna 402B · St. Louis, MOWhile taxiing in close to deplane his passengers, the commuter pilot pulled in behind a parked northwest orient 727. As he approached the rear of the 727, the pilot turned the Cessna 402B to the right so that the passenger door would be facing the gate. As…NTSB MKC81FA017Accident · No injuriesClosedCessna 402B · Tebbetts, MO