NTSB investigations, GA
7 cases where the first occurrence was “Gear collapsed”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 3 |
| 1994 | 1 |
| 1999 | 1 |
| 2002 | 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\" = 'GA' 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\" = 190)
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" = 'GA' 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" = 190) 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 ATL02FA113Accident · No injuriesField investigationFinal reportBombardier CL600-2B19 · Atlanta, GAFailure of the left main landing gear fitting due to a fatigue crack that emanated from multiple origins at the external surface of the wall at the shock strut radius run out area for undetermined reasons.NTSB MIA00LA016Accident · No injuriesLimited investigationFinal reportCessna 152 · Cornelia, GAthe pilot misjudged the flare, causing the airplane to porpoise, and subsequently impact with the runwayNTSB ATL94LA147Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Chamblee, GAThe fatigue failure of the left main landing gear shock absorbing strut that resulted in a loss of control.NTSB ATL83IA302Incident · No injuriesIncident investigationFinal reportMooney M20C · St.Simonsisland, GAAcft had neither a green light nor mechanical indication of safe gear confirmed by the tower. All landing gear collapsedon touchdown. The motor to actuator coupling which is common to both electric & manual landing gear systems failed.NTSB ATL83FA282Accident · No injuriesField investigationFinal reportPiper PA-34-22OT · Atlanta, GAThe acft was on a takeoff roll when the left main and nose gear retracted. Investigation revealed a flt switch for the hobbs meter had been installed to automatically record only flt time when the switch was in the flt position. In this postion the hobbs…NTSB ATL83FA189Accident · No injuriesField investigationFinal reportPiper PA-30 · Atlanta, GAAccording to the plt, he extended the gear, got a safe gear down indication & made an approach with the flaps retracted. The gear warning was not heard. The plt stated that after the acft rolled about 1500 ft after touchdown, and with all 3 gear on the…NTSB ATL82DA250Accident · No injuriesFinal reportCessna 310C · Brunswick, GAThe pilot experienced an electrical failure inflight after takeoff. He hand-cranked the landing gear to the down and locked position prior to landing. After rolling approximately 200 feet, he left main gear collapsed. Examination of the landing gear revealed…