NTSB investigations: Cessna 402C, 2017
3 cases on aircraft the registry lists as Cessna 402C. 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
| 1972 | 1 |
|---|---|
| 1980 | 2 |
| 1981 | 2 |
| 1982 | 1 |
| 1983 | 1 |
| 1984 | 6 |
| 1985 | 4 |
| 1986 | 2 |
| 1987 | 4 |
| 1988 | 2 |
| 1989 | 3 |
| 1990 | 1 |
| 1991 | 4 |
| 1992 | 4 |
| 1993 | 3 |
| 1994 | 7 |
| 1997 | 7 |
| 1998 | 2 |
| 1999 | 2 |
| 2000 | 5 |
| 2001 | 2 |
| 2002 | 3 |
| 2003 | 4 |
| 2004 | 3 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 1 |
| 2008 | 2 |
| 2009 | 3 |
| 2010 | 2 |
| 2012 | 1 |
| 2015 | 1 |
| 2017 | 3 |
| 2018 | 1 |
| 2019 | 2 |
| 2020 | 2 |
| 2021 | 3 |
| 2022 | 1 |
| 2023 | 2 |
| 2024 | 1 |
| 2026 | 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 year(c.\"eventDate\") = 2017
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('207590R'))
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 year(c."eventDate") = 2017
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('207590R'))
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 GAA18CA071Accident · No injuriesData collectionFinal reportCessna 402 · Hyannis, MAEncounter with a flock of birds during takeoff at night, resulting in multiple bird strikes and structural damage.NTSB CEN17WA291Incident · No injuriesForeign investigationCessna 402 · British Virgin Islands, British Virgin IslandsOn July 27, 2017, a Cessna 402C airplane, N618CA, exited the prepared surface during an aborted takeoff at the Terrance B. Lettsome International Airport, British Virgin Islands. The pilots and occupants were not injured and the airplane was not damaged.The…NTSB CEN17WA107Accident · No injuriesForeign investigationCessna 402C · Virgin Gorda, British Virgin IslandsOn February 11, 2017, at 2004 UTC, a Cessna 402C, N603AB, experienced brake failure during landing roll and impacted terrain at the Virgin Gorda Airport (TUPW), British Virgin Islands. The pilot and 8 passengers on board were not injured. The airplane…