NTSB investigations, OH
16 cases where the first occurrence was “Nose over”.
Cases per year
| 1984 | 1 |
|---|---|
| 1986 | 2 |
| 1988 | 1 |
| 1989 | 2 |
| 1990 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1996 | 2 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 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\" = 'OH' 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" = 'OH' 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 NYC02LA031Accident · No injuriesLimited investigationFinal reportMaule M7-260 · North Lima, OHThe pilot's failure to retract the landing gear, which resulted in a wheels down landing on water.NTSB NYC01LA228Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Kenton, OHThe pilot's failure to stop the airplane within the available runway. Factors included the uneven braking and the pilot's lack of experience in airplane make and model.NTSB NYC00LA194Accident · No injuriesLimited investigationFinal reportCessna 140 · Alliance, OHThe pilot's improper decision to abort the takeoff. A factor in this accident was the dark night conditions.NTSB NYC99LA233Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Minerva, OHThe pilot's failure to maintain directional control.NTSB NYC98LA083Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Milford Center, OHthe pilot's excessive application of brakes during an aborted takeoff roll.NTSB IAD96LA059Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Waynesville, OHThe pilot's failure to maintain control of the accident aircraft during the landing roll. Factors were the wet portion of the grass runway and the pilot's selection of a landing runway with a 10 knot quartering tailwind.NTSB IAD96LA051Accident · No injuriesLimited investigationFinal reportMulholland Witchawk · Celina, OHthe pilot's selection of unsuitable terrain for a precautionary landing.NTSB NYC94LA124Accident · No injuriesLimited investigationFinal reportCessna 140 · Mount Vernon, OHThe pilot's inadequate handling which resulted in the airplane nosing over during the takeoff roll.NTSB NYC92LA115Accident · No injuriesLimited investigationFinal reportCessna 140 · Wauseon, OHThe pilot improperly used the brakes, resulting in the airplane nosing over.NTSB ATL90LA085Accident · No injuriesLimited investigationFinal reportCessna 172K · Columbus, OHImproper planning/decision by the pilot. A factor related to the accident was: the adverse wind condition.NTSB CHI89DEI01Accident · No injuriesFinal reportCox/Pitts Special S-1S · Alliance, OHFailure of the pilot to maintain proper runway alignment. The soft terrain was a related factor.NTSB ATL89LA129Accident · No injuriesLimited investigationFinal reportCessna 152 · Gratis, OHThe foreign material (bird nest) in the engine compartment, and failure of the dual student or instructor pilot (CFI) to identify and remove it during their preflight inspection of the aircraft. Soft terrain in the emergency landing area and smoke from the…NTSB ATL88LA148Accident · No injuriesLimited investigationFinal reportCessna 182Q · Lowell, OHThe plt rptd that he landed in a 12-14 kt, 90 degree x-wind. The initial portion of the ldg rollout was shielded from the wind by a row of trees bordering part of the upwind side of the rwy. Upon reaching a clearing in the trees, the airplane was exposed to…NTSB ATL87LA015Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Ada, OHPlt stated that elevator control was lost during the landing roll. Acft nosed over inverted and received substantial damage. Investigation revealed that the lower cable to elevator bellcrank forward turnbuckle was fractured. Bellcrank was badly corroded. Last…NTSB CHI86LA061Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Mount Gilead, OHAccording to the arpt manager, the plt was taxiing down the active in gusty wind conditions at a fairly rapid rate of speed. As the plt turned into the run-up pad area the acft nosed over.NTSB CHI84LA149Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Leesburg, OHThe plt decided to land in a hay field to talk to the farmer about the aerial seeding operation he was conducting. During the landing the plt said the acft hit a soft spot in the field and nosed over.