Skip to content

NTSB investigations, 2007

15 cases where the first occurrence was “Wheels up landing”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19932026

Where

Latest cases

Query with SQL

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") = 2007 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" = 232) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\") = 2007
    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\" = 232)
  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") = 2007
  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" = 232)
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 NYC08CA073Accident · No injuriesData collectionFinal reportPiper PA-31T · Muscle Shoals, ALThe pilot's failure to lower the landing gear.Dec 13, 2007 · N112ED · Substantial damage NTSB SEA08LA025Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Salt Lake City, UTThe pilot's failure to lower the landing gear prior to landing. Contributing to the accident was the pilot's failure to use a written checklist.Nov 12, 2007 · N84859 · Substantial damage NTSB DEN08LA012Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Trinidad, COThe pilot's failure to extend the landing gear.Oct 9, 2007 · N313RA · Substantial damage NTSB DFW07CA209Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Pampa, TXThe pilot's failure to extend the landing gear prior to landing.Sep 28, 2007 · N45014 · Substantial damage NTSB SEA07CA268Accident · No injuriesData collectionFinal reportMooney M20D · Placerville, CAThe pilot's failure to extend the landing gear prior to landing. A contributing factor was the pilots impaired performance.Sep 12, 2007 · N1229X · Substantial damage NTSB LAX07CA255Accident · No injuriesData collectionFinal reportBeech D55 · Heber, UTThe pilot's failure to lower the landing gear during landing.Aug 17, 2007 · N7947R · Substantial damage NTSB DEN07CA116Accident · No injuriesData collectionFinal reportCessna T210N · Loveland, COThe pilot's failure to lower the landing gear. Contributing factors were the pilot's attention being diverted, and his failure to use the BEFORE LANDING checklist.Jul 3, 2007 · N5129C · Substantial damage NTSB LAX07CA196Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Boulder City, NVthe pilot's failure to extend the landing gear.Jul 1, 2007 · N6370P · Substantial damage NTSB DFW07CA132Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Madison, MSThe pilot's failure to extend the landing gear prior to landing.Jun 10, 2007 · N987MD · Substantial damage NTSB DFW07LA158Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Rockport, TXThe pilots improper landing flare which resulted in a hard landing. Contributing factors were the pilot's delayed actions to abort a wheels-up landing.Jun 2, 2007 · N4977S · Substantial damage NTSB LAX07CA159Accident · No injuriesData collectionFinal reportCessna T210L · The Dalles, ORThe pilot's failure to extend the landing gear.May 11, 2007 · N66CE · Substantial damage NTSB CHI07CA109Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Walker, MNThe pilot's inadvertent failure to lower the landing gear.Apr 13, 2007 · N770C · Substantial damage NTSB MIA07LA068Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-83 (MD-83) · Sanford, FLThe flight crew's failure to complete the checklist and adhere to airplane placards. Contributing to the accident was a separation of a B-nut on the rudder power hydraulic shut off valve for undetermined reasons.Mar 29, 2007 · N877GA · Substantial damage NTSB LAX07CA110Accident · No injuriesData collectionFinal reportCessna T210N · Barstow, CAThe pilot's failure to properly execute the manual landing gear extension procedures.Mar 16, 2007 · N628TT · Substantial damage NTSB CHI07CA088Accident · No injuriesData collectionFinal reportPiper PA-24-400 · Des Moines, IAthe nose landing gear becoming jammed in a partially extended position during flight as a result of damage to the nose landing gear by ground personnel.Mar 13, 2007 · N400VL · Substantial damage