NTSB investigations, NV
7 cases where the first occurrence was “Nose over”.
Cases per year
| 1983 | 1 |
|---|---|
| 1988 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1994 | 1 |
| 2001 | 1 |
| 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\" = 'NV' 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" = 'NV' 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 LAX02LA087Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Beatty, NVThe pilot failed to maintain control of the airplane.NTSB LAX01LA230Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Nixon, NVThe pilot’s failure to attain the proper touchdown point and his misjudged distance/speed during landing rollout. Factors were the tailwind condition and the downhill landing area.NTSB LAX94LA183Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Beowawe, NVthe pilot's inadvertent application of the brakes combined with excessive forward control pressure during recovery from a bounced landing.NTSB LAX91LA119Accident · No injuriesLimited investigationFinal reportCessna 172G · Reno, NVThe pilot's improper planning/preparation decision. Factors related to the accident were the high wind condition and the pilot in commands inability to compensate for the wind condition.NTSB SEA90LA009Accident · Minor injuriesLimited investigationFinal reportCessna 182D · Reno, NVThe inadequate compensation for gusty wind conditions.NTSB SEA88LA056Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Las Vegas, NVThe student pilot departed the airport for a cross country flight without filing a flight plan or obtaining a weather briefing. Upon returning to the originating airport he discovered that the winds were unfavorable for landing at that airport. The pilot then…NTSB LAX83LA282Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Yerrington, NVThe acft nosed over during a landing in a field near Yerrington, NV. After police found empty beer cans & some unidentified drugs in the aircraft, the plt resisted arrest & assaulted the officers. When interviewed at a hospital, he stated 'it was his time to…