NTSB investigations, CT
8 cases where the first occurrence was “Undershoot”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1985 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1995 | 2 |
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\" = 390)
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" = 390) 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 DCA96MA008Accident · Minor injuriesClass 1 · MajorFinal reportMcDonnell Douglas MD-83 · East Granby, CTthe flightcrew's failure to maintain the required minimum descent altitude until the required visual references identifiable with the runway were in sight. Contributing factors were the failure of the BDL approach controller to furnish the flightcrew with a…NTSB BFO95LA061Accident · Serious injuriesLimited investigationFinal reportConsolidated-Vultee BT-13B · Oxford, CTthe pilot's failure to maintain sufficient altitude/clearance from terrain. The low ceiling was a related factor in the accident.NTSB NYC94LA080Accident · No injuriesLimited investigationFinal reportDavis DK-1 · East Haddam, CTThe pilot's failure to maintain the proper glidepath during landing approach.NTSB NYC92LA183Accident · Minor injuriesLimited investigationFinal reportBeech A24 · Griswold, CTThe pilot failed to maintain control of the airplane which resulted in the airplane touching down short of the intended touchdown point, and collapsing the landing gear.NTSB NYC90LA146Accident · No injuriesLimited investigationFinal reportde Havilland DH-82-A · Burlington, CTThe pilot's inadequate compensation for the wind condition.NTSB NYC85LA235Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Madison, CTWhile on the downwind leg for rwy 24, the instructor reduced power to idle for engine failure simulation. The student made a short approach and upon reaching 700 ft AGL the student headed directly toward the approach end of the rwy at a 30 deg angle from rwy…NTSB NYC83FNE05Accident · Serious injuriesFinal reportI.C.A. Brasov IS28B2 "LARK" · North Canaan, CTTwo witnesses observed the glider on a downwind that was, in their estimation, lower than normal. One witness reported observing the spoilers extended. The plt stated he extended the flaps on downwind, but had not used the spoilers. Duringthe turn to base…NTSB NYC83LA027Accident · No injuriesLimited investigationFinal reportCessna 402 · Danielson, CTOn final the pilot realized he was late in reducing power and attempted to correct by abruptly bringing power back. A high sink rate was experienced and the pilot immediately applied full power. The aircraft impacted short of the runway.