NTSB investigations, CT
16 cases where the first occurrence was “On ground/water collision with object”.
Cases per year
| 1982 | 1 |
|---|---|
| 1984 | 3 |
| 1987 | 2 |
| 1989 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2003 | 1 |
| 2004 | 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.\"eventStateOrRegion\" = 'CT' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 310)
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 310) 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 NYC08LA004Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Hartford, CTThe pilot's failure to maintain adequate clearance from a parked airplane while taxiing. Contributing to the accident was the proximity of the parked airplanes to the taxiway and the failure of the marshaller to provide adequate guidance.NTSB NYC04LA099Accident · No injuriesLimited investigationFinal reportBeech 1900D · Windsor Locks, CTThe fuel truck driver's failure to maintain clearance with a taxiing airplane, resulting in the collision between the fuel truck and the airplane. A factor in the accident was the night condition.NTSB NYC03LA053Accident · No injuriesLimited investigationFinal reportCessna 180 · East Windsor, CTThe pilot's failure to maintain directional control. A related factor was the snow-covered runway conditions.NTSB NYC00IA076Incident · No injuriesIncident investigationFinal reportCessna 182P · Hartford, CTThe pilot's failure to maintain a visual lookout.NTSB IAD98LA041Accident · No injuriesLimited investigationFinal reportCessna 152 · Windsor Locks, CTThe student pilot's inattention during taxi, which resulted in the collision with a fuel truck.NTSB NYC96LA064Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Stratford, CTinadequate visual lookout by the pilot and the vehicle operator, resulting in their failure to see and avoid each other.NTSB NYC94LA093Accident · No injuriesLimited investigationFinal reportCessna 172M · Groton, CTthe pilot's inadequate visual lookout during taxi, which resulted in the airplane's wing tip striking ground support equipment.NTSB NYC92LA098Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-32 · New Milford, CTInadequate visual lookout by the pilot which resulted in the glider striking a vehicle parked next to the runway.NTSB NYC91LA043Accident · Minor injuriesLimited investigationFinal reportCessna 210L · New Haven, CTThe failure of the vehicle driver to adequately monitor the radio/traffic pattern. Factors related to the accident were: darkness, the aircraft's loss of electrical power after activating the runway lights and entering the pattern, and the lack of visual…NTSB NYC90LA005Accident · No injuriesLimited investigationFinal reportCessna 170B · Burlington, CTThe aircraft colliding with a steel drum placed on the runway by unknown person(s) to mark a pothole area.NTSB NYC87LA228Accident · No injuriesLimited investigationFinal reportCessna 172 · Groton, CTThe aircraft was taxiing to the ramp after landing. While the pilot was maneuvering the aircraft into a parking space, the aircraft was positioned in such a way that the sun had blinded him temporarily. As the pilot turned the aircraft the left wing contacted…NTSB NYC87LA243Accident · No injuriesLimited investigationFinal reportBeech C24R · Danbury, CTDuring a landing at late dusk, the aircraft collided with a deer that darted onto the runway. The pilot said there was no time to take evasive action before the collision. The left wing and left gear door were damaged and the left fuel tank was ruptured.NTSB NYC85LA026Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Waterford, CTN3772M (acft 'a') was on lndg roll on runway 15 when N19091 (acft 'b') initiated taxi across the runway. Acft 'a' swerved to avoid collision but inadequate clrnc was available. Right wing of acft 'a' collided with left wing of acft 'b'. Plt of acft 'b' stated…NTSB NYC84LA100Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · New Haven, CTWhile taxiing in from landing and maneuvering for parking the acft contacted a light pole. The CFI was reportedly at theacft controls at the time of the collision. The right wing was damaged in the collision.NTSB NYC84IA091Incident · No injuriesIncident investigationFinal reportLockheed 382G · Groton, CTAfter landing on rwy 33, and during taxi to the ramp, the lt wing tip of the acft struck a parked DC-3.NTSB NYC83LA036Accident · No injuriesLimited investigationFinal reportFokker F-27-100 · New Haven, CTAircraft collided with a power cart as taxi to takeoff began.