NTSB investigations, 2000, OR
5 cases where the first occurrence was “Nose over”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 3 |
| 1994 | 1 |
| 1995 | 4 |
| 1996 | 1 |
| 1998 | 1 |
| 2000 | 5 |
| 2001 | 2 |
| 2002 | 3 |
| 2003 | 2 |
| 2006 | 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 year(c.\"eventDate\") = 2000
AND c.\"eventStateOrRegion\" = 'OR' 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 year(c."eventDate") = 2000 AND c."eventStateOrRegion" = 'OR' 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 SEA01LA027Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Gleneden Beach, ORThe pilot's excessive application of main wheel brakes. Factors include the pilot's failure to maintain directional control and his inadequate remedial action during his attempt to regain control.NTSB SEA01LA020Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Ontario, ORInadequate remedial action by the first pilot. The student pilot's improper flare while landing was a factor.NTSB SEA00LA189Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Corvallis, ORThe instructor pilot's delayed remedial action. Factors include the student's failure to properly initiate a flare, and the soft terrain immediately adjacent to the taxiway.NTSB SEA00LA168Accident · No injuriesLimited investigationFinal reportCessna 172B · Sunriver, ORThe pilot's improper decision to continue the takeoff after the aircraft failed to climb or accelerate immediately after the initial liftoff. Factors were inadequate preflight planning, to include the pilot's failure to calculate takeoff performance data,…NTSB SEA00LA167Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A-150 · North Plains, ORThe pilot's excessive use of brakes. Contributing factors were the pilot's misjudgment of distance/speed (landing long and fast) and lack of experience in the make/model of aircraft.