NTSB investigations, AR
17 cases where the first occurrence was “Nose over”.
Cases per year
| 1982 | 1 |
|---|---|
| 1984 | 2 |
| 1985 | 1 |
| 1986 | 1 |
| 1988 | 1 |
| 1989 | 2 |
| 1990 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1998 | 3 |
| 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\" = 'AR' 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\" = 300)
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" = 'AR' 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" = 300) 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 FTW02LA111Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Wynne, ARThe inadequate supervision by the flight instructor of the pilot who was receiving instruction resulting in the excessive application of the brakes during the landing roll resulting in a nose over. A factor was the gusty crosswind conditions.NTSB FTW98LA218Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Dumas, ARThe pilot's improper activation of the parking brake.NTSB FTW98LA140Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Lake Village, ARThe pilot's use of unsuitable terrain for takeoff. A factor was the rough/uneven terrain.NTSB FTW98LA087Accident · No injuriesLimited investigationFinal reportStarduster SA-100 · Roland, ARThe pilot's inadvertent encounter with soft, wet grass during landing.NTSB FTW95LA192Accident · 1 fatalLimited investigationFinal reportWSK PZL Mielec M-18A Dromader · Gerome, ARThe pilot's use of unsuitable terrain for landing.NTSB FTW94LA163Accident · No injuriesLimited investigationFinal reportGulfstream G-164C · Weiner, ARThe pilot selected unsuitable terrain for the takeoff.NTSB FTW93LA180Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Dumas, ARThe pilot's inadequate compensation for wind conditions.NTSB FTW92LA078Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Gillette, ARThe unsuitable terrain selected by the pilot.NTSB MKC90LA080Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Mounds, ARThe pilot's improper compensation for wind conditions. Factors related to the accident were: the pilot's selection of the wrong runway and the resultant tailwind condition.NTSB MKC89LA129Accident · Minor injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Wynne, ARUnsuitable terrain selected by the pilot. A contributing factor was the rough/uneven landing area.NTSB MKC89LA070Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Griffithville, ARThe failure of the pilot to assure suitable terrain was being used for the landing.NTSB MKC89LA023Accident · No injuriesLimited investigationFinal reportStearman B75N1 · Benton, ARThe flt was uneventful until the landing at the saline county arpt, Benton, ark. The PIC stated he applied too much brake and applied it prematurely during the landing roll and the acft nosed over to the inverted posn. The resultant impact crushed the…NTSB MKC86LA161Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Lewisville, ARThe PIC made a landing to a rain soaked sod rwy when the acft's right main gear fell into a large mud hole during the landing roll and the acft flipped inverted. The subsequent flipping action substantially damaged the acft.NTSB MKC85LA158Accident · No injuriesLimited investigationFinal reportCessna 152 · Corning, ARThe student plt became disoriented while on a solo cross country flt. When the acft became low on fuel the plt decided to land on a plowed fld. The fld was soft and the acft nosed over shortly after touchdown.NTSB MKC84LA199Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Sherrill, ARThe plt stated he was landing with a slight tailwind & the new brake system on the acft was sensitive. During touchdown,the acft nose over.NTSB MKC84LA112Accident · No injuriesLimited investigationFinal reportCessna A188B · Mcgehee, ARThe plt stated that he made a wheel landing in an ag strip. As the forward speed decresaed, the tail was lowered to the ground. The acft was nearly stopped when the tail started up & the acft nosed over. The plt stated that before the accident, the winds were…NTSB FTW82DA328Accident · No injuriesFinal reportPiper PA-18-150 · Devalls Bluff, ARThe pilot was flying over his farm and decided to land in a freshly plowed field. During the rollout, the main gear settled in the loose dirt and the plane nosed over.