NTSB investigations, CT
5 cases where the first occurrence was “Miscellaneous/other”.
Cases per year
| 1982 | 2 |
|---|---|
| 1985 | 1 |
| 1987 | 1 |
| 1999 | 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\" = 430)
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" = 430) 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 NYC99LA229Accident · No injuriesLimited investigationFinal reportCessna 305A · Warehouse Point, CTThe pilot's misjudgment of the clearance between the airplane and the banner loop during banner pickup.NTSB NYC87DNE04Accident · 1 fatalFinal reportPiper PA-28-180 · Groton, CTShortly after the aircraft departed the airport, air traffic control personnel received a distress call from the non-pilot rated passenger. She stated that the pilot (her husband) was incapacitated by an apparent heart attack and she was not qualified to fly…NTSB NYC85LA101Accident · No injuriesLimited investigationFinal reportBeech B-35 · East Haddam, CTThe acft stalled and contacted sandy terrain aprx 50 ft from the rwy threshold. The plt reported the cabin door opened during takeoff and he circled the traffic pattern to land and close the door. He stated an airspeed of 100 KTS was observed on a 1 mile…NTSB NYC82DA109Accident · No injuriesFinal reportRobinson R-22 · Danbury, CTDuring a practice autorotation, just prior to flare, a loud noise was heard and the pilot stated that the aircraft veered to the right. A partial flare was made and after making contact with the ground the helicoper bounced back into the air. The rotor blades…NTSB NYC82DA106Accident · No injuriesFinal reportSchleicher ASW-15 · Plymouth, CTThe pilot stated that he thought he heard the rudder pedals click into their detented/locked position when they were adjusted before takeoff. However, while being towed for takeoff, the rudder pedals slipped forward about 1 to 2 inches. The pilot reached down…