NTSB investigations, MO
10 cases where the first occurrence was “Nose over”.
Cases per year
| 1982 | 1 |
|---|---|
| 1985 | 1 |
| 1990 | 2 |
| 1992 | 1 |
| 1998 | 1 |
| 2000 | 2 |
| 2002 | 2 |
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\" = 'MO' 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" = 'MO' 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 CHI03LA026Accident · Minor injuriesLimited investigationFinal reportA Pair of Jacks RV-6A · Belton, MOThe punctured nose landing gear tire.NTSB CHI02LA204Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Farmington, MOThe locked brake and the aircraft control not being possible due to the locked brake.NTSB CHI00LA216Accident · No injuriesLimited investigationFinal reportMonocoupe 90A · Creve Coeur, MOthe excessive brakes applied by the second pilot. A factor to the accident was the unavailability of brakes on the flight instructor's side of the aircraft.NTSB CHI00LA106Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Saint Joseph, MOthe pilot's inadequate compensation for the wind condition. A factor to the accident was the high winds.NTSB CHI98LA202Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Risco, MOthe pilot's abrupt application of the brakes. Factors contributing to this accident were the pilot's inadequate preflight preparation, his delayed decision to abort the takeoff, and the soft field.NTSB CHI92LA246Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Chillicothe, MOThe pilot's improper use of the airplanes brakes.NTSB CHI90LA216Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Salisbury, MOProper touchdown point not attained and go-around not performed by the PIC.NTSB MKC90LA125Accident · No injuriesLimited investigationFinal reportCessna 205 · Jonesburg, MOThe pilot in commands failure to attain a touchdown on the runway resulting in touchdown to the side of the runway and a nose over in soft terrain.NTSB MKC85LA058Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Waldron, MOThe acft nosed over inverted after the left landing gear wheel contacted snow alongside the rwy during a touch and go.NTSB MKC82DA101Accident · No injuriesFinal reportCessna 150 · St Louis, MODuring a local flight to practice touch and go landings, the aircrew elected to proceed to the creve coeur airport, where there was less traffic. The instructor pilot had recently moved to the St Louis area. Neither he nor his student had landed at the creve…