NTSB investigations, 1987
14 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\") = 1987
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") = 1987 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 ANC88FA022Accident · Minor injuriesField investigationFinal reportCessna 208 · Bethel, AKThe plt had planned to back taxi for takeoff on rwy 36. The tower controller asked if a rwy 18 departure would be acceptable to accommodate an arriving acft & the plt accepted a clnc. He started his takeoff with 3900' remaining on the 6399' rwy. After initial…NTSB ATL88LA064Accident · No injuriesLimited investigationFinal reportCessna 150G · Grantham, NCThe airplane touched down initially on the nose wheel, and the nose landing gear collapsed. The airplane subsequently nosed over. The student plt reportedly had about 2 hrs total PIC (solo) flt time.NTSB LAX88LA044Accident · No injuriesLimited investigationFinal reportBeech D18S · Mokuleia, HIThe plt rprtd that he had made a normal preflight, but after the acft had rolled about 200 to 250 ft on the takeoff roll, the nose gear collapsed. The acft came to rest with damage to the nose section, props & engs. Drg an inspn of the acft, the landing gear…NTSB NYC88LA038Accident · No injuriesLimited investigationFinal reportGrumman AA-1B · Tewksbury, MAThe student pilot was attempting a landing at Tewksbury, Massachusetts when he flared above the runway, bounced several times and collapsed the nose wheel. The aircraft slid down the runway, made contact with the right side of the runway edge, spun around,…NTSB SEA88LA006Accident · No injuriesLimited investigationFinal reportCessna 206 · Winnemucca, NVThe acft nose gear collapsed during takeoff and the acft nosed over. The plt stated to inspectors that recent maintenance had been performed on the nose gear. Shortly after the accident the acft was locked in a hangar. The plt has failed to file an accident…NTSB FTW87LA216Accident · No injuriesLimited investigationFinal reportCessna 172 · Edmond, OKThe pilot executed a short field approach to a private airstrip. During the landing roll the nose gear collapsed resulting in the aircraft's nose contacting the terrain. No reason for the nose gear collapse could be determined.NTSB BFO87LA058Accident · Minor injuriesLimited investigationFinal reportBeech D50C · Somerville, VAThe nose gear prematurely retracted and the props contacted the gravel runway during the takeoff initial climb. The plt attempted to continue the takeoff and the acft settled into trees off the departure end of the rwy. Post-accident inspection failed to…NTSB FTW87LA176Accident · No injuriesLimited investigationFinal reportPiper PA28R-201 · Houston, TXAccording to the pilot, during takeoff roll, and at the point of rotation the nose gear failed, causing the aircraft to drop down striking the runway with the prop. The aircraft then became airborne for approx. 15 sec. The pilot landed the aircraft on an…NTSB SEA87LA130Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Olympia, WADuring landing roll the pilot was unable to maintain directional control. The aircraft veered to the side of the runway onto soft terrain. The aircraft then nosed over inverted. Investigation revealed that the nose gear had collapsed but the reason for the…NTSB ATL87LA180Accident · No injuriesLimited investigationFinal reportLockheed L-382-30 · Dayton, OHThe flight experienced separation of the nose landing gear during the landing roll. Investigation showed that the failure was related to the progression of a preexisting crack on the nose landing gear strut assembly. The probelms with the nose landing gear…NTSB FTW87LA117Accident · No injuriesLimited investigationFinal reportCessna 152 · Okmulgee, OKDuring a normal uneventful approach, and upon touchdown, the aircraft's nose gear collapsed for undetermined reasons. The aircraft slid to a stop causing substantial damage.NTSB FTW87LA104Accident · No injuriesLimited investigationFinal reportCessna 182 · Midland, TXDuring a touch and go landing on a sod strip the nose gear collapsed. The strut assembly part number 0594300-5 failed for an undetermined reason and the aircraft nosed over to the inverted position.NTSB MIA87LA112Accident · No injuriesLimited investigationFinal reportCessna 182C · Branford, FLThe plt was unable to locate his postion, & with wx conditions deteriorating & darkness approaching, elected to land in a field. Upon touchdown, the nose gear broke off, the acft nosed over & came to rest inverted.NTSB MKC87LA045Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Flippin, ARThe pilot stated that immediately upon touchdown, the nose slowly descended to the runway. The airplane slid for 450 feet before it stopped. A support bracket and an angle was found broken. It has not been determined if the parts were broken before or after…