NTSB investigations, 1995
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
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\") = 1995
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") = 1995 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 NYC96LA045Accident · No injuriesLimited investigationFinal reportCessna 150J · Kutztown, PAthe student pilot's selection of an unsuitable runway for landing. The snow covered runway was a related factor.NTSB LAX96LA070Accident · No injuriesLimited investigationFinal reportCessna 208B · Sacramento, CAthe pilot was given an erroneous wind velocity due to a malfunctioning wind gauge in the control tower. Factors relating to the accident were: the high/gusty wind conditions, and the pilot's improper evaluation of the actual wind condition.NTSB NYC96LA030Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Kutztown, PAthe pilot's improper use of brakes during the landing roll resulting in the airplane nosing over.NTSB BFO96LA025Accident · No injuriesLimited investigationFinal reportSellors Kitfox IV · Pasadena, MDThe pilot's improper (abrupt) application of brakes during the landing roll. Factors relating to the accicent were: the pilot's failure to attain the proper touchdown point during the landing, and his lack of experience in the make and model of airplane.NTSB SEA96LA018Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Seeley Lake, MTThe pilot's selection of unsuitable terrain for landing. The snow covered runway was a factor.NTSB SEA96LA017Accident · No injuriesLimited investigationFinal reportPiper PA-22 · La Grande, ORThe pilot's poor judgment in attempting flight in the existing wind conditions.NTSB ANC96TA011Accident · Minor injuriesFinal reportBellanca 8GCBC · Fairbanks, AKThe pilot's inadequate recovery from a bounced landing. The snow-covered landing surface and the pilot's decision not to perform a go-around were factors.NTSB ANC96LA010Accident · No injuriesLimited investigationFinal reportCessna 185 · Kodiak, AKThe check pilot's inadequate compensation for wind conditions. Factors relating to the accident were: the rough water and adverse wind conditions.NTSB FTW96LA023Accident · No injuriesLimited investigationFinal reportCessna 172D · Pryor, OKThe high wind and the pilot's poor judgment in attempting the flight.NTSB FTW96LA015Accident · Minor injuriesLimited investigationFinal reportAdams Kitfox · Seminole, TXthe pilot's excessive braking.NTSB ANC96LA004Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Tyonek, AKImproper planning/decision by the pilot concerning his method of testing the landing area. His selection of an unsuitable area was a related factor.NTSB FTW96LA006Accident · No injuriesLimited investigationFinal reportDonegan Benton Kitfox II · Seguin, TXthe pilot's improper braking technique.NTSB ANC95LA145Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Skwentna, AKThe pilot's improper planning/decision. A factor relating to the accident was: the pilot's selection of a short/uneven landing area that required excessive braking action while landing with a tailwind.NTSB NYC95LA186Accident · No injuriesLimited investigationFinal reportCessna 150E · West Addison, VTThe pilot's selection of an unsuitable landing area. A factor is a soft landing area.NTSB ATL95LA133Accident · No injuriesLimited investigationFinal reportCessna 172 · Bayboro, NCThe pilot's inadequate procedure in that he elected to land the aircraft on unsuitable terrain with no mechanical malfunctions.NTSB ANC95LA096Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Homer, AKThe pilot's improper (excessive) use of the brakes after the airplane crested the landing site's crown and started downhill.NTSB SEA95LA115Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Medford, ORAn unreliable fuel quantity gage and an inadequate preflight. The tall vegetation in the landing area was a factor.NTSB ANC95LA064Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Big Delta, AKThe pilot's failure to maintain proper alignment with the landing surface. A factor relating to the accident was: the rough/uneven landing surface.NTSB SEA95LA100Accident · No injuriesLimited investigationFinal reportBoeing E75 · Newberg, ORThe pilot's improper use of the aircraft brakes. Contributing to the accident was the pilot's decision not to perform a go-around, which resulted in failure to attain the desired touchdown point on landing.NTSB ANC95TA054Accident · No injuriesFinal reportBellanca 8GCBC · Fairbanks, AKThe pilot's failure to verify the position of the parking brake knob prior to landing.NTSB FTW95LA192Accident · 1 fatalLimited investigationFinal reportWSK PZL Mielec M-18A Dromader · Gerome, ARThe pilot's use of unsuitable terrain for landing.NTSB LAX95LA166Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Chino, CAfailure of the attachment link for the master cylinder return spring, which allowed the left brake to lock.NTSB ANC95GA083Accident · No injuriesFinal reportPiper PA-18 · Copper Center 2, AKThe pilot not using the checklist and landing with the skis pumped down.NTSB BFO95LA041Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Allentown, PAthe pilot's inadequate compensation for wind conditions. Related factors were the gusty wind conditions and the pilot's poor weather evaluation.NTSB SEA95LA073Accident · No injuriesLimited investigationFinal reportFleet 7 · Arlington, WAThe pilot-in-command's improper use of the brakes. A factor was the failure to maintain directional control during landing rollout.NTSB NYC95LA062Accident · No injuriesLimited investigationFinal reportCessna 172L · Saratoga Spgs, NYThe pilot's poor judgment in attempting a flight under the existing wind conditions.NTSB SEA95LA047Accident · No injuriesLimited investigationFinal reportCessna 120 · Scappoose, ORThe pilot's improper recovery from a bounced landing and inadvertent use of the brakes.NTSB SEA95LA036Accident · No injuriesLimited investigationFinal reportCessna 172G · Salt Lake City, UTThe pilot's inadequate compensation for wind conditions during runup. The unfavorable wind was a factor.NTSB LAX95LA071Accident · No injuriesLimited investigationFinal reportCessna 175 · Davis, CAthe failure of the pilot to maintain directional control of the aircraft while on the rollout phase of landing on a dirt road. A factor in the accident was the pilot's intentional selection of the road as a landing site.