NTSB investigations, PA
11 cases where the first occurrence was “Nose over”.
Cases per year
| 1982 | 3 |
|---|---|
| 1985 | 2 |
| 1993 | 1 |
| 1995 | 3 |
| 2000 | 1 |
| 2007 | 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\" = 'PA' 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" = 'PA' 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 NYC07CA127Accident · Minor injuriesData collectionFinal reportWroblewski Searey · Freeport, PAThe pilot's improper flare, which resulted in a nose over while attempting to land on a river. A factor in this accident was the glassy water landing conditions.NTSB NYC00LA182Accident · No injuriesLimited investigationFinal reportCessna 180 · Jackson Center, PAA seized left brake as reported by the pilot.NTSB NYC96LA045Accident · No injuriesLimited investigationFinal reportCessna 150J · Kutztown, PAthe student pilot's selection of an unsuitable runway for landing. The snow covered runway was a related factor.NTSB NYC96LA030Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Kutztown, PAthe pilot's improper use of brakes during the landing roll resulting in the airplane nosing over.NTSB BFO95LA041Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Allentown, PAthe pilot's inadequate compensation for wind conditions. Related factors were the gusty wind conditions and the pilot's poor weather evaluation.NTSB BFO93LA037Accident · No injuriesLimited investigationFinal reportCessna 182Q · Gettysburg, PAThe pilot's inadequate in-flight decision to land on the snow covered runway that was not currently maintained. Contributing to the pilot's decision was the inadequate report of the runway's condition.NTSB NYC85LA130Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Pittsburgh, PAThe personal transportation flight took off from allegheny co. ariport and made one landing back at the airport. The flight then departed the airport and made a landing on the water with the wheels down causing the aircraft to tip o ver onto its back.NTSB NYC85LA102Accident · No injuriesLimited investigationFinal reportCessna 172 · Kintnersville, PAThe pilot decided to abort the takeoff when he realized that too much runway was being used. During the rollout, the pilot began to turn the aircraft to the right. The wind lifted the tail of the aircraft until it nosed over onto its back.NTSB NYC82DA202Accident · No injuriesFinal reportPiper PA-22-160 · Tunkhannock, PADuring a landing in calm wind conditions, the aircraft was high on final approach, so the pilot added flaps and slipped the plane to lose altitude. He touched down about 1000 ft down the 2000 ft runway. He reported that after landing, he applied the brakes,…NTSB NYC82FGM13Accident · Serious injuriesFinal reportCessna 150D · Patton, PAThe student pilot departed johnston, PA at about 2000 EDT on a return flight to ebensburg, PA. He saw the destination airport at about 2015 EDT and elected to fly locally and practice maneuvers. At about 2045 EDT, he became lost and flew a large rectangular…NTSB NYC82DA016Accident · No injuriesFinal reportCessna 172 · Galeton, PAAfter takeoff from the original departure point, the pilot flew to a local airport and landed on runway 28. The runway was covered with snow and the winds were from 270 degrees at 10 knots. After landing, the pilot taxied back for takeoff. While in a right…