NTSB investigations, PA
6 cases where the first occurrence was “Nose gear collapsed”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 2 |
| 1985 | 1 |
| 1989 | 1 |
| 1990 | 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\" = 'PA' 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\" = 192)
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" = 'PA' 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" = 192) 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 NYC91LA027Accident · No injuriesLimited investigationFinal reportCessna 404 · Pittsburgh, PAA failure of nose landing gear retraction cylinder attach points which allowed the nose landing gear to collapse.NTSB NYC89LA108Accident · No injuriesLimited investigationFinal reportBeech TC-45J · Johnstown, PAFailure of the pilot to maintain runway alignment. The crosswind and snow covered runway were related factors.NTSB NYC85LA176Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Hookstown, PAThe instructor and student were practicing normal takeoffs and landings. According to the pilot, on the sixth landing, at the correct airspeed, the aircraft touched down on the main gear and then the noise wheel collapsed. The aircraft then nosed over.…NTSB NYC84LA062Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · West Mifflin, PADuring the cockpit preflight the plt noticed an unsafe nose gear indication. The plt checked the nose gear & could see nothing unusual, & concluded that there was a faulty indicating system. During rotation the nose gear collapsed & this acft slid down the…NTSB NYC83IA056Incident · No injuriesIncident investigationFinal reportSmith, Ted Aerostar 600 Aerostar · Philadelphia, PAThe aircraft veered off the runway during landing. The weather was VMC at the time. When the landing gear was lowered for landing no discrepancies were noted by the pilot prior to touchdown. During touchdown the aircraft veered to the left. The pilot took…NTSB NYC82DA069Accident · No injuriesFinal reportCessna 310 · Pittsburgh, PAAfter takeoff a loud bang was heard during gear retraction. A fly by the tower confirmed that the nose gear was not in the locked position and all attempts to lock it failed. Touchdown was made on the main landing gear and after the airspeed dissipated to…