NTSB investigations, GA
14 cases where the first occurrence was “Nose over”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 3 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1998 | 1 |
| 2001 | 1 |
| 2004 | 2 |
| 2005 | 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\" = 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" = '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" = 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 ATL06CA017Accident · No injuriesData collectionFinal reportCessna 120 · Woodstock, GAThe pilot's excessive braking resulted in a nose over during landing roll.NTSB ATL05CA004Accident · Serious injuriesData collectionFinal reportLuscombe LL-8 · Jasper, GAThe pilot's excessive braking during landing roll resulted in a nose over.NTSB ATL04CA102Accident · No injuriesData collectionFinal reportPiper PA-18 · Cedartown, GAThe pilot's improper use of brakes during landing roll which resulted in the airplane nosing over.NTSB MIA02LA007Accident · No injuriesLimited investigationFinal reportCessna A150L · Buena Vista, GAThe pilot's failure to use proper bounced landing technique, resulting in a hard touchdown, propeller strike, and noseover.NTSB ATL98LA101Accident · No injuriesLimited investigationFinal reportWaco WMF · Chamblee, GAThe pilot's excessive taxi speed and excessive braking action that resulted in a nose over.NTSB ATL91LA137Accident · No injuriesLimited investigationFinal reportCessna 182 · Jenkinsburg, GAThe separation of the nose wheel, during the landing roll, for undetermined reasons.NTSB ATL89LA107Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Swainsboro, GAThe pilot's decision to land at an unlighted airstrip in low light conditions, and her subsequent, inadvertent selectionof unsuitable terrain bordering the runway.NTSB ATL86LA091Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Hampton, GADuring landing roll the pilot was unable to keep the tailwheel on the ground and the aircraft nosed over. Post crash examination of the wreckage disclosed that the brake pads were worn down to the rivets.NTSB ATL85LA281Accident · No injuriesLimited investigationFinal reportCessna A188B · Baxley, GAPlt attempted ldg in cultivated field after sowing load of rye grass seed. Grnd was soft and wheel dug in and acft nosed over. Plt was not injured.NTSB ATL84LA161Accident · No injuriesLimited investigationFinal reportWaco RNF · Thomaston, GADuring the landing roll the acft drifted to the side of the sod strip where a wheel encountered a surface deviation. The acft turned & nosed over.NTSB ATL84LA067Accident · No injuriesLimited investigationFinal reportCessna 182P-SYLANE · Damascus, GAThe plt, an auctioneer, had rented the acft to fly to a farm where he was to conduct an auction. Previously, he had inspected the intended landing area, a soy bean field, & thought it would be satisfactory for a landing. When he arrived & landed, the main…NTSB ATL83LA157Accident · No injuriesLimited investigationFinal reportPiper PA-28 · St. Marys, GAThe canadian private pilot (plt) & his canadian instructor (CFI) were on a training flt, practicing a soft field, touch-and-go landing. (The plt was in training for a commercial certificate.) While landing in a x-wind, the plt allowedthe acft to contact the…NTSB ATL83LA130Accident · No injuriesLimited investigationFinal reportRockwell Intl S-2R · Marshallville, GAThe plt reported that he was taking off with a load of fertilizer from a newly constructed strip that was wet and soft. He stated that he failed to clear a mud-hole at the end of the strip, the wheels mired in the mud, and the acft nosed over.NTSB ATL82DA277Accident · No injuriesFinal reportCessna 120 · Hawkinsville, GAThe aircraft nosed over while landing in a peanut field. The pilot reported that the terrain was softer than he realized, and when he applied brake pressure, the plane nosed over. He believed the accident would not have occurred it brakes had not been applied.