NTSB investigations, MO
6 cases where the first occurrence was “Abrupt maneuver”.
Cases per year
| 1984 | 1 |
|---|---|
| 1985 | 1 |
| 1988 | 3 |
| 1994 | 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\" = '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\" = 100)
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" = 100) 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 CHI95DCA01Accident · 1 fatalFinal reportYakovlev YAK-52 · Caruthersville, MOThe insufficient altitude (300 feet above the airport) at which an aerobatic maneuver was attempted by the pilot.NTSB MKC89FA004Accident · Serious injuriesField investigationFinal reportHughes 500C · Branson, MOThe flight was conducted for sightseeing with 5 passengers onboard. The pilot turned on final approach with 35 knots of airspeed and encountered a high rate of descent. The pilot reported that he noted a split tach and initiated an autorotation, but was…NTSB MKC88FA072Accident · 1 fatalField investigationFinal reportBeech H18 · Kansas City, MOThe cargo flt dptd cincinnati enrt to wichita, KS with an intermediate stop at Kansas City dtwn arpt. The flt progressed nrmly to a VOR rwy 03 instrument apch, circling to rwy 01. The PIC had been clrd to commence the apch. Twr pers subsequently advised the…NTSB MKC88FA040Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Creve Coeur, MOWitnesses stated that the aircraft suddenly started a vertical climb from a straight and level flight attitude. The airplane lost momentum while in the climb, then it nosed down and dove towards the ground. It exploded upon impact and was destroyed in the…NTSB MKC85LA081Accident · No injuriesLimited investigationFinal reportEhlers Starduster ESA300 · Kansas City, MOThe plt stated that during the landing roll he noticed an acft landing behind his and therefore veered his acft to the right of rwy 36 traveling about 45 mph. During the maneuver the plt felt the right gear give and the acft consequently ground looped twice…NTSB MKC84LA279Accident · No injuriesLimited investigationFinal reportCessna 182D · Rolla, MOThe plt tried to 'balloon' over a pack of dogs on the rwy and stalled the acft. The resulting hard landing failed the nose gear and damaged the firewall.