NTSB investigations, 1984
16 cases where the first occurrence was “Nose gear collapsed”.
Cases per year
| 1982 | 22 |
|---|---|
| 1983 | 16 |
| 1984 | 16 |
| 1985 | 15 |
| 1986 | 9 |
| 1987 | 14 |
| 1988 | 10 |
| 1989 | 9 |
| 1990 | 10 |
| 1991 | 3 |
| 1992 | 5 |
| 1993 | 16 |
| 1994 | 5 |
| 1995 | 6 |
| 1996 | 9 |
| 1997 | 10 |
| 1998 | 3 |
| 1999 | 4 |
| 2000 | 6 |
| 2002 | 4 |
| 2003 | 4 |
| 2004 | 3 |
| 2005 | 5 |
| 2006 | 4 |
| 2007 | 6 |
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 year(c.\"eventDate\") = 1984
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 year(c."eventDate") = 1984 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 LAX85LA064Accident · No injuriesLimited investigationFinal reportBeech B-60 · Van Nuys, CADuring landing roll out the plt observed the acft's nose gear begin to collapse. Although on approach the plt had placed the ldg gear selector in the down position & had observed the illumination of the green gear down lights, the plt responded to the…NTSB MIA85IA032Incident · No injuriesIncident investigationFinal reportPiper PA-34-200 · Miami, FLThe nose cear collapsed during a landing. An exam disclosed that the hydraulic actuator firewall mounting bracket had failed prior to complete extension of the nose gear. Piper service bulletin, sb 413, related to this problem; however, no logbook entry was…NTSB ATL85LA025Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar Aerostar 600A · Charlotte, NCDuring final approach the pilot was unable to lower the nose gear therefore he landed with the nose gear retracted. Post crash examination revealed that the nose steering actuating bolt was fractured. The facture surfaces exhibited signatures of a progressive…NTSB LAX85LA032Accident · No injuriesLimited investigationFinal reportCessna 152 · Fillmore, CAAccording to the pilot, unforecast wx was encountered in cruise at 6,500 ft. the student became lost and elected to make a precautionary landing in an unimproved field. The nose gear collapsed on touchdown and the acft nosed over coming to rest inverted. No…NTSB LAX84LA490Accident · No injuriesLimited investigationFinal reportCessna 411 · Dolan Springs, AZAfter lndg, the plt was taxiing back up the rwy to a parking area when the nose wheel 'fell into' a sand filled depression in the surface, collapsing the nose gear. County maintenance personnel had graded the rwy surface after heavy rains but no compaction…NTSB FTW84LA410Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Kerrville, TXPlt stated that after failing to get a 'gear down' light, he cycled gear with no success in obtaining a light and received no response to call on UNICOM frequency for visual check from ground. Plt stated he elected to land anyway and that nose gear collapsed…NTSB MIA84LA228Accident · No injuriesLimited investigationFinal reportDouglas C-54 · Ft.Lauderdale, FLThe acft had returned for precautionary landing after #4 engine vibration was noted 10 mins into the flt. Acft landed 4000 lbs over max allowable landing wt. After #4 engine examination the acft was released for flight. An exchangeof pilot in command was made…NTSB ATL84LA249Accident · No injuriesLimited investigationFinal reportCessna 150J · Leesville, SCThe pilot stated that while attempting to takeoff from a 1600 ft strip he was, 'unhappy with the thakeoff roll'. An aborted takeoff was initiated and when brakes were applied hard the nose gear collapsed and the aircraft nosed over.NTSB LAX84LA408Accident · Minor injuriesLimited investigationFinal reportNesmith Cougar 1 · Williams, AZWhile en route, the plt elected to land at the Williams muni arpt for a rest stop. He noted that rwy 2/20 was closed; however, he observed what appeared to be a new gravel strip, oriented north/south & an airplane on the arpt. The plt assumed the arpt was…NTSB ANC84LA115Accident · No injuriesLimited investigationFinal reportCessna U-206 · Naknek, AKThe acft nosed over during a landing on a sandy beach. Witnesses stated, according to the plt, that the nose wheel was cocked 45 degrees to the right while the acft was on the final approach. Upon touchdown the acft veered to the right, the nose gear…NTSB ATL84LA132Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-20 · Charlotte, NCUpon landing the nose landing gear sheared off the acft. Exam of the nose gear revealed that two fatigue cracks had propogated to the point of total failure. The gear was the subject of an airworthiness directive that required inspection of the gear…NTSB LAX84LA202Accident · No injuriesLimited investigationFinal reportCessna 152 · Emigrant Gap, CAThe student & instructor plt (CFI) were on a dual x-country flt. They proceeded to fly to an unattended arpt at Emigrant Gap, CA, which was at an elevation of 5284 ft. after arriving, they circled the arpt & made a low pass over the rwy. They saw tracks on…NTSB CHI84LA117Accident · Minor injuriesLimited investigationFinal reportCessna T-210N · Troy, MIThe acft landed in soft grassy terrain alongside rwy 27, when the acft nosed over the nose gear collapsed. The plt was not aligned properly because the north side of the rwy lights were not operating and were notamed as being out of service since 2/19/84.NTSB ATL84FKG02Accident · No injuriesFinal reportPiper PA-60 · Atlanta, GAWhile on final approach the plt noted an unsafe nose gear indication. Tower personnel were unable to determine gear position during a fly-by. During landing touchdown the nose gear collapsed. Investigation revealed the acft had a brokenbolt in the nose gear…NTSB FTW84LA134Accident · No injuriesLimited investigationFinal reportCessna 152 · Stillwater, OKDuring landing the nose gear of the acft collapsed. The plt reported that the nose gear started to shimmy after landing and he pulled the stick back to raise the nose gear. When the gear contacted the rwy again it collapsed. Examination of the wreckage showed…NTSB SEA84LA051Accident · No injuriesLimited investigationFinal reportCessna 172 Rgii · Seattle, WADuring a takeoff after a touch and go landing the nose gear retracted at about the time of rotation. Power was reduced to idle and the acft slid to a stop. This acft is equipped with squat switches which prevent gear retraction when the weight of the acft…