NTSB investigations, 1989
29 cases where the first occurrence was “Nose over”.
Cases per year
| 1982 | 62 |
|---|---|
| 1983 | 41 |
| 1984 | 42 |
| 1985 | 27 |
| 1986 | 31 |
| 1987 | 25 |
| 1988 | 20 |
| 1989 | 29 |
| 1990 | 25 |
| 1991 | 29 |
| 1992 | 29 |
| 1993 | 25 |
| 1994 | 31 |
| 1995 | 29 |
| 1996 | 24 |
| 1997 | 17 |
| 1998 | 24 |
| 1999 | 16 |
| 2000 | 28 |
| 2001 | 23 |
| 2002 | 22 |
| 2003 | 13 |
| 2004 | 11 |
| 2005 | 11 |
| 2006 | 12 |
| 2007 | 19 |
Where
Latest 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\") = 1989
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 year(c."eventDate") = 1989 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 ANC90LA016Accident · No injuriesLimited investigationFinal reportCessna 180 · Alexander Lake, AKSelection of unsuitable terrain by the pilot. The snow covered terrain was a related factor.NTSB LAX90LA043Accident · No injuriesLimited investigationFinal reportCessna 140 · Concord, CAImproper use of the brakes by the pilot. The crosswind and the pilot's failure to maintain runway alignment were contributing factors.NTSB DEN90LA018Accident · No injuriesLimited investigationFinal reportCessna U206B · Billings, MTImproper planning/decision by the pilot while taxiing during unfavorable wind conditions.NTSB NYC90LA020Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Lowell, MAThe failure of the pilot to assure that the float wheels were retracted prior to a water landing. A contributing factor was the extension of the left float wheels for an undetermined reason.NTSB SEA90LA009Accident · Minor injuriesLimited investigationFinal reportCessna 182D · Reno, NVThe inadequate compensation for gusty wind conditions.NTSB CHI90LA007Accident · No injuriesLimited investigationFinal reportCessna 140A · Peoria, ILInadequate compensation for wind conditions by the pilot. The tailwind, the pilot's improper use of brakes, and his lack of recent experience in the type of aircraft were considered to be contributing factors.NTSB NYC90LA007Accident · No injuriesLimited investigationFinal reportCessna 185F · Rockwood, METhe pilot's improper compensation for the gusting crosswind. Contributing factor(s) was: the wind conditions and the pilot's selection of a touchdown point.NTSB ATL90LA004Accident · No injuriesLimited investigationFinal reportCessna 170 · Mooresville, NCImproper in-flight planning/decision by the pilot, which resulted in his failure to attain the proper toughdown point on the unidirectional runway. Factors related to the accident were: the unfavorable wind and terrain conditions.NTSB ANC89LA167Accident · Serious injuriesLimited investigationFinal reportCessna A185F · Nenana River, AKImproper planning/decision by the pilot. A factor related to the accident was: the adverse weather condition.NTSB ANC89LA156Accident · No injuriesLimited investigationFinal reportde Havilland DHC-3 · Sheenjek River, AKFailure of the pilot to go around when he was unable to attain the proper touchdown point and his excessive application of brakes during the landing. Contributing factors were: the downdraft, excessive remedial action, and soft terrain.NTSB ANC89LA153Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Gulkana, AKThe pilots improper use of brakes during the landing roll.NTSB ANC89LA152Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Talkeetna, AKImproper planning/decision by the plt. Contributing factors were rough terrain, rain, high density altitude, tailwind, gusts, and the pilot's improper use of brakes.NTSB ANC89LA105Accident · No injuriesLimited investigationFinal reportHelio H800 · King Salmon, AKThe pilot selected unsuitable terrain for the landing. Soft/wet (muddy) terrain conditions were contributing factors.NTSB ANC89LA097Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Sheshalik, AKPilot-in-command's failure to perform an adequate preflight inspection of the airplane's brakes.NTSB CHI89DEI01Accident · No injuriesFinal reportCox/Pitts Special S-1S · Alliance, OHFailure of the pilot to maintain proper runway alignment. The soft terrain was a related factor.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 LAX89LA206Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Big Sur, CAThe pilot elected to attempt a takeoff from a field that he had previously made a forced landing to and the airplane nosed over during the attempt. Contributing to the accident was the high grass that became entangled in the tailwheel and the soft downhill…NTSB ANC89LA077Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Green Island, AKFailure of the pilot to select a suitable landing area. Factors related to the accident were: rough water conditions, and the pilot's lack of experience in this make and model of aircraft.NTSB NYC89LA132Accident · No injuriesLimited investigationFinal reportCessna 150 · Woodstock, CTInadequate compensation for wind conditions by the pilot which resulted in not maintaining proper alignment with the runway. The crosswind and soft/wet terrain were contributing factors.NTSB LAX89DVG06Accident · No injuriesFinal reportGrumman G-164B · Davis, CAThe pilot failed to properly use his brakes during the off airport landing.NTSB ANC89LA065Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Wasilla, AKFailure of the pilot to go-around when he did not attain the proper touchdown point, which required excessive use of brakes to stop on the short landing area.NTSB ANC89LA066Accident · No injuriesLimited investigationFinal reportCessna 150A · Chisana, AKThe pilot's selection of unsuitable terrain for the landing. The soft/uneven terrain is considred to be a contributing factor.NTSB ATL89LA129Accident · No injuriesLimited investigationFinal reportCessna 152 · Gratis, OHThe foreign material (bird nest) in the engine compartment, and failure of the dual student or instructor pilot (CFI) to identify and remove it during their preflight inspection of the aircraft. Soft terrain in the emergency landing area and smoke from the…NTSB LAX89LA148Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Lancaster, CAImproper planning/decision by the pilot. Strong/gusty winds contributed to the accident.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 MKC89LA070Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Griffithville, ARThe failure of the pilot to assure suitable terrain was being used for the landing.NTSB SEA89LA046Accident · No injuriesLimited investigationFinal reportCessna 180J · Elk City, IDThe pilot's failure to maintain a proper runway alignment on touchdown. Contributing to the accident were the soft snow conditions on the ranch airstrip.NTSB LAX89DVG03Accident · Minor injuriesFinal reportEaa WAG-AERO Sport · Placerville, CAThe student's improper application of brakes during the touchdown/flare phase of the landing causing the aircraft to nose over.NTSB SEA89LA032Accident · No injuriesLimited investigationFinal reportCessna 185F · Juneau, AKThe misjudgement of the runway conditions on the part of the pilot prior to landing. Contributing to the accident were deep snow on the runway, box canyon configuration of the area precluding runway overflight, marginal weather/light conditions for assessing…