NTSB investigations: Cessna U206G
9 cases on aircraft the registry lists as Cessna U206G, where the first occurrence was “Overrun”. 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
| 1982 | 1 |
|---|---|
| 1989 | 1 |
| 1991 | 1 |
| 1994 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2007 | 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 ('2073356', '2073315', '2073314')
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\" = 340))
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 ('2073356', '2073315', '2073314')
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" = 340))
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 LAX07CA275Accident · Minor injuriesData collectionFinal reportCessna U206G · Fort Bragg, CAThe pilot's misjudged speed and distance, which resulted in a landing overrun of the runway.NTSB IAD01LA103Accident · No injuriesLimited investigationFinal reportCessna U206G · Millersburg, OHThe pilot's misjudgment of speed and distance, which resulted in an overrun during landing. Factors were the short, wet, grass runway, and his failure to do a go-around.NTSB IAD00LA058Accident · Serious injuriesLimited investigationFinal reportCessna 206 · Annapolis, MDThe pilot's failure to attain the proper touchdown point, and his failure to perform a go-around.NTSB ANC98LA090Accident · No injuriesLimited investigationFinal reportCessna 206G · Aleknagik, AKThe pilot's failure to attain a proper touchdown point during landing. A factor associated with the accident is the presence of a variable wind condition, and the pilot's decision not to perform a go-around.NTSB ANC97TA098Accident · Minor injuriesFinal reportCessna U206G · Platinum, AKThe pilot's misjudgment of the proper touchdown point. A factor associated with the accident was a tailwind.NTSB ANC94LA102Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Bethel, AKThe pilot misjudged the strength of the tailwind and did not perform a go-around in a timely fashion so as to avoid landing the airplane halfway down the strip. Factors in the accident were the wet landing strip and the tailwind.NTSB LAX91LA287Accident · No injuriesLimited investigationFinal reportCessna C-U206B · Novato, CAThe pilot improperly used the mixture control, failed to attain the airspeed and delayed in aborting the takeoff.NTSB ANC89LA165Accident · No injuriesLimited investigationFinal reportCessna U206 · Nondalton, AKFailure of the pilot to attain the proper touchdown point for the landing, his excessive airspeed, and his misjudgement of runway distance remaining. Factors related to the accident were: loose/wet gravel on the runway and the location of the parked aircraft…NTSB SEA83LA021Accident · No injuriesLimited investigationFinal reportCessna U206 · Cove, ORPilot landed on icy runway and slid 1200 feet into the river.