NTSB investigations, CT
13 cases where the defining event was Runway excursion.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 1 |
| 2012 | 1 |
| 2015 | 2 |
| 2016 | 2 |
| 2020 | 1 |
| 2022 | 1 |
| 2025 | 2 |
| 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 c.\"eventStateOrRegion\" = 'CT' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '300')
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" = 'CT' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '300') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run 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 ERA26LA229Accident · No injuriesClass 4 · LimitedFinal reportHawker Beechcraft G36 · Danbury, CTThe pilot’s decision to abort the takeoff with insufficient runway remaining, which resulted in a runway excursion.NTSB ERA26LA015Accident · No injuriesClass 4 · LimitedFinal reportSocata TB 10 · New Milford, CTThe pilot’s decision to depart from an unlit turf runway at night, which resulted in a loss of directional control, and subsequent runway excursion.NTSB ERA25LA279Accident · No injuriesClass 4 · LimitedFinal reportBeech A23-24 · Windham, CTThe pilot’s inadequate preflight planning, which resulted in a rejected takeoff and subsequent runway excursion.NTSB ERA22LA253Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Simsbury, CTThe pilot’s delayed decision to abort the landing, which resulted in a runway overrun.NTSB ERA20CA294Accident · No injuriesClass 4 · Data collectionFinal reportSocata TB200 · Simsbury, CTA runway excursion following an aborted takeoff in tailwind conditions.NTSB ERA16CA308Accident · No injuriesData collectionFinal reportBeech C23 · Simsbury, CTThe student pilot’s failure to attain the proper touchdown point, which resulted in a runway overrun.NTSB ERA16LA122Accident · No injuriesLimited investigationFinal reportCessna 152 · Chester, CTThe pilot’s failure to maintain directional control of the airplane during the landing, which resulted in a runway excursion.NTSB ERA15LA356Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Stratford, CTThe pilot's failure to maintain directional control while landing in a crosswind.NTSB ERA15LA322Accident · Minor injuriesLimited investigationFinal reportEclipse EA500 · Danbury, CTThe pilot's failure to attain the proper touchdown point and exceedance of the target touchdown speed, which resulted in a runway overrun.NTSB ERA12CA436Accident · No injuriesData collectionFinal reportPiper PA-28-236 · Chester, CTThe pilot’s failure to execute a go-around following an approach that was high and fast, which resulted in a runway overrun.NTSB ERA09LA339Accident · No injuriesLimited investigationFinal reportPilatus PC-12/47 · Bridgeport, CTThe flight crew's misjudgment of speed and distance, which resulted in an overrun of the wet runway.NTSB ERA09CA034Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-5B · Bridgeport, CTThe pilot's loss of directional control during landing and while suffering symptoms of vertigo.NTSB CHI08LA185Accident · No injuriesLimited investigationFinal reportTraxler John N Kitfox · Hartford, CTThe pilot's failure to compensate for crosswinds resulting in a loss of directional control while landing. Contributing to the accident was the pilot's lack of experience and training in tailwheeled airplanes.