NTSB investigations, NM
5 cases where the first occurrence was “Nose over”.
Cases per year
| 1983 | 1 |
|---|---|
| 1987 | 1 |
| 1990 | 1 |
| 1997 | 1 |
| 1999 | 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\" = 'NM' 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" = 'NM' 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 DEN99LA073Accident · Minor injuriesLimited investigationFinal reportDavis RV-6A · Truth Or Cnsqnc, NMA soft runway surface that caused the airplane to nose over.NTSB FTW98LA029Accident · No injuriesLimited investigationFinal reportCessna 185C · Farmington, NMthe pilot's improper preflight of the airplane, by failing to properly set the elevator trim for takeoff, and his improper use use of the elevator flight controls. A related factor was: the pilot's lack of recent experience in the make and model of airplane.NTSB DEN90DQA02Accident · No injuriesFinal reportGrumman G-164A · Deming, NMFailure of the pilot to maintain control during landing roll due to the condition of the runway. Contributing to the accident was the poor maintenance of the runway surface.NTSB DEN87LA227Accident · No injuriesLimited investigationFinal reportCessna 182Q · Albuquerque, NMThe instructor took control of the acft to make the landing due to excessive crosswind. The ip stated that the apch speed was 70 to 75 KTS. The acft was landed on the first third of runway and brakes applied with half runway remaining. Ip reported that brake…NTSB FTW84LA080Accident · No injuriesLimited investigationFinal reportCessna 180A · Portales, NMThe plt had made a successful landing in an unimproved wheat field. The acft had stopped & as the plt was making a 180 deg turn back the wind caught a wing causing the acft to nose over onto its back. The plt stated that during the turn the right main gear…