NTSB investigations, AL
7 cases where the first occurrence was “Nose over”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 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\" = 'AL' 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" = 'AL' 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 ATL94LA145Accident · No injuriesLimited investigationFinal reportChampion 7-GCBC · Hartford, ALThe pilot's improper use of the wheel brakes.NTSB ATL91LA174Accident · No injuriesLimited investigationFinal reportCessna 150J · Wilsonville, ALThe pilot's inadequate preflight planning, and his improper use of flaps during the takeoff roll. Factors in the accident were: the high density altitude, the rising runway conditions, and the departure end obstructions at the airstrip.NTSB ATL90LA143Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Fort Payne, ALThe pilot's selection of a runway which afforded a tailwind, and his improper use of the elevator control during the landing roll.NTSB ATL87LA077Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Dothan, ALThe plt reported that the acft nosed over when he applied the brakes during ldg roll-out. He estimated his groundspeed to be about 15-20 mph at the time.NTSB ATL85LA265Accident · No injuriesLimited investigationFinal reportBellanca Champion 7GCAA · Alabaster, ALThe plt lost directional control of the acft during a landing. The acft nosed over coming to rest inverted. The plt related that a gust of wind caused the loss of control.NTSB ATL84LA004Accident · No injuriesLimited investigationFinal reportMaule M-6-235 · Elberta, ALThe plt took off with a passenger, who was also a plt, but was not performing as such on this flt. After returning to the arpt, the plt landed on the north-south rwy. He stated that during the landing roll, he encountered a x-wind that caused the acft to…NTSB ATL82DA230Accident · No injuriesFinal reportGrumman G164B · Opp, ALThe pilot reported that while he was spraying, vibrations occurred in the left flying wires. He had experienced the vibrations before, but this time, they seemed worse, he elected to land in a nearby pasture to examine the aircraft. During the landing…